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...
Forum Discussion
Try this in your [Current Date] field:
If(is null[Moved to Date],[Orig Date],[Moved to Date])
------------------------------
Jeff Peterson
------------------------------
If(is null[Moved to Date],[Orig Date],[Moved to Date])
------------------------------
Jeff Peterson
------------------------------