Discussions

Expand all | Collapse all

Duration to Numeric not working

  • 1.  Duration to Numeric not working

    Posted 03-06-2020 12:13
    I am trying to calculate the difference between an actual and forecast date using the following formula:

    If(not IsNull([Master Data - PA Date]), ToNumber(ToText([Master Data - Scheduled Finish Date - CCD] - [CCD at T - 7] )))

    The only results that are populating are the ones where both dates match, Then I get a 0 as expected.  but I don't get positive or negative numbers displaying if the dates do not match.

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Duration to Numeric not working

    Posted 03-06-2020 12:48
    try this

    If(not IsNull([Master Data - PA Date]), ToDays([Master Data - Scheduled Finish Date - CCD] - [CCD at T - 7] ))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Duration to Numeric not working

    Posted 03-06-2020 14:38

    Thank you!

    That resolved the problem!  Found one other glitch as well.  I'm still getting used to the QuickBase Syntax



    ------------------------------
    Paul Peterson
    ------------------------------