Forum Discussion

JefferyTorres's avatar
JefferyTorres
Qrew Member
2 years ago

Formula - Date Help

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
------------------------------

1 Reply

  • Try this in your [Current Date] field:

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

    ------------------------------
    Jeff Peterson
    ------------------------------