Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Converting Date Field to Workdate

Hey everyone,

I'm attempting to fix some issues i'm having with a calendar displaying duration and not including the start date in the count (So giving me 1 extra day on the calendar). I was looking on the Formula page and noticed the WeekdayAdd() function can be formatted 2 ways:

WeekdayAdd(Date d, Number n)
Which I'm currently using...

And...
WeekdayAdd(WorkDate d, Number n)
Which I'm attempting to get to...

The (WorkDate d, Number n) says it will include the date in one of the days for the calculation. 

How can I convert my Date field to be a WorkDate field to be included in the count for duration, so my Calendar Report is accurate?

Any help would be appreciated!

Thanks,

------------------------------
Alex Bennett
------------------------------
Formulas and functions
Tables and fields
    • AlexBennett3's avatar
      AlexBennett3
      Qrew Trainee
      5 years ago
      Ive attempted this function. Still get errors when trying to change from Date to Workdate.

      ------------------------------
      Alex Bennett
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        5 years ago
        My issue is I have the [Start Date], then I just created a new field to use to convert this from Date to WorkDate. But even if I use ToWorkDate() I just keep getting errors because it says expecting workdate not x.

        ------------------------------
        Alex Bennett
        ------------------------------