Please assist with date formula?
The formula below the line works fine. Now, I need to add the other scenario which is: If the customer name is NVR and ifinvoice is submitted within the week (Friday being the last day), payments fo...
Forum Discussion
This works fine for Customer 1 [SM JOB]
var date BillingDate = [DW 1 BILLED];
var date SameDayNextMonth = (AdjustMonth($BillingDate,1));
If(Day($BillingDate) <= 15, Date(Year($SameDayNextMonth), Month($SameDayNextMonth),10),
Date(Year($SameDayNextMonth), Month($SameDayNextMonth),25))
Now, I need a different date result for Customer 2
IF([NVR JOB]=true,
...the return date needs to be 30 days after the billing date.
Please advise...I cannot seem to get () in correct places. thx
Thank you. Seems to be working. Now that this works, can we add the following:
...the actual return date should be on a Friday.
For example:
Current return date is on Wed., 6/6/18 (but could be on any day within the week)...so final return date should be Fri., 6/8
...the actual return date should be on a Friday.
For example:
Current return date is on Wed., 6/6/18 (but could be on any day within the week)...so final return date should be Fri., 6/8