Incrementing a date by 2 business days?
I've a field called output date which needs to be incremented by 2 business days per input date e.g. Input date + 2 business days =Output date Can you please help with the formula that can do thi...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
WeekDayAdd([Input Date Date],2)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
WeekDayAdd([Input Date Date],2)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Great! thank you Mark!
However, Field type of Input Date field is date/time. Could you please help with it?
------------------------------
Mrunali Kadam
------------------------------- MarkShnier__YouOK, a bit more complicated ....
var date NewDate = WeekdayAdd(ToDate([date & time field]),2);
var timeofday TOD = ToTimeOfDay([date & time field]);
ToTimestamp($NewDate, $TOD)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Perfect. It worked!
As always thank you very much for the quick turnaround :)
------------------------------
Mrunali Kadam
------------------------------
