Skip to main content
Question

Formula - Date Help

  • June 10, 2022
  • 0 replies
  • 26 views
Scenario

Orig Date (date type) = 1/1/2022
Moved to Date (date type) = 2/1/2022
Current Date (Formula - date type) = Blank

I need help writing out the formula for [Current Date] to reflect - IF [Moved to Date] Is Null then show [Orig Date] but If [Moved to Date] shows any date, reflect that date in [Current Date]. 

Hopefully this makes sense!
Cheers,

------------------------------
Jeffery Torres
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • June 10, 2022
Try this in your [Current Date] field:

If(is null[Moved to Date],[Orig Date],[Moved to Date])

------------------------------
Jeff Peterson
------------------------------
Terms & ConditionsAccessibility statement