Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
3 years ago

Formula on Date/Time field

I am looking to find 15 weekdays prior to the training start date. However the Training Start Date field is a Date/Time field and the below formula is giving me an error. How can I fix the formula without having to change the Training Start Date field type.

WeekdayAdd(, -15)


------------------------------
NOEL HODGES
------------------------------
Formulas and functions

2 Replies

Sort By
  • MattHardy's avatar
    MattHardy
    Qrew Trainee
    3 years ago
    Hi Noel,

    Give this a shot: WeekdayAdd(ToDate(), -15)

    That converts to a Date field
    • NOELHODGES's avatar
      NOELHODGES
      Qrew Cadet
      3 years ago
      This worked perfectly! Thank you !

      ------------------------------
      NOEL HODGES
      ------------------------------