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