Forum Discussion
BuildPro
7 years agoQrew Captain
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
BuildPro
7 years agoQrew Captain
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