Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
2 years ago

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 this calculation?

My current formula for the output date field (([Input Date Date]+Days(2))) doesn't understand business days logic and directly increments by 2 days.

------------------------------
Mrunali Kadam
------------------------------
Formulas and functions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    np
    WeekDayAdd([Input Date Date],2)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MrunaliKadam's avatar
      MrunaliKadam
      Qrew Trainee
      2 years ago
      Great! thank you Mark!

      However, Field type of Input Date field is date/time. Could you please help with it? 

      ------------------------------
      Mrunali Kadam
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        OK, 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
        ------------------------------