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
- I think you will need to use something like
If([NVR Job]=true, $BillingDate+Days(30), ......) - 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 - Disregard. I have resolved the Friday issue. thx
- NextDayOfWeek (Date d, Number n)
Description: Returns the first day after the given date d that falls on the weekday n.
n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on.
Example: NextDayOfWeek([Date Submitted], 2) returns the first Tuesday that follows the Date in the Date Submitted field.
