Skip to main content
Question

Date & Duration Formula

  • May 29, 2019
  • 0 replies
  • 52 views
Forum|alt.badge.img+8
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." 

    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])
    Terms & ConditionsAccessibility statement