Discussions

Expand all | Collapse all

Converting Date Field to Workdate

  • 1.  Converting Date Field to Workdate

    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: Converting Date Field to Workdate

    Posted 11 days ago
    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/
    ------------------------------



  • 3.  RE: Converting Date Field to Workdate

    Posted 11 days ago
    Ive attempted this function. Still get errors when trying to change from Date to Workdate.

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



  • 4.  RE: Converting Date Field to Workdate

    Posted 11 days 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
    ------------------------------



  • 5.  RE: Converting Date Field to Workdate

    Posted 11 days ago
    Nevermind, found the problem deeper in my code.

    Thanks Blake.

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