Skip to main content
Question

Converting Date Field to Workdate

  • November 18, 2020
  • 0 replies
  • 88 views

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
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • November 18, 2020
Here's a function from the Help documentation:

https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fi&rl=w8

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------