Duration to Numeric not working
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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry 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
------------------------------
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
------------------------------
Thank you!
That resolved the problem! Found one other glitch as well. I'm still getting used to the QuickBase Syntax
------------------------------
Paul Peterson
------------------------------