Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
6 years ago

Date & Duration Formula

Hello:

I am trying to calculate results in a new Date - Formula field [Days Aging Beyond Target]

Days ( Today()-[Target End Date])

[Target End Date] is a Date - Formula field as well.  I am getting "Expecting Date But Found Number." 
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    I suggest that you change your formula field to be a formula numeric field type and change your formula to 

    ToDays( Today()-[Target End Date])