Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
4 years ago

Formula help (Start date + number of days)

Hey everyone, I'm having an issue getting my formulas to display on a Calendar report correctly. The start date is never 'included' in the count of days for the job duration, so on the Calendar I a...
Formulas and functions
AlexBennett3's avatar
AlexBennett3
Qrew Trainee
Is there a way to convert a Date field to Workdate? I'm attempting the WeekdayAdd function, but my start date is just the field type date. On the formulas page it says it can be used with Workdate as well? This sounds like my issue as having WeekdayAdd(WorkDate d, Number n) Sounds like it will include the start date as the duration. As WeekdayAdd(Date d, Number n) which I'm currently using, does not. I'm just not sure how to change the type to Workdate in my start date fields. Maybe Formula - Date, and add a certain formula to do so?

------------------------------
Alex Bennett
------------------------------
AlexBennett3's avatar
AlexBennett3
Qrew Trainee
4 years ago
Nevermind, found the problem in my process and made some changes to different layers of code.

Thanks Mark.

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