Forum Discussion
Solved
Custom Column to Replace Date Using "If"
if [TENTATIVE REMOVAL DATE] <= Date.From(DateTime.LocalNow()) then Date.From(DateTime.LocalNow()) +1
else [TENTATIVE REMOVAL DATE])
*I want to replace any dates that are prior to today w/ tomorrow's date
I am getting this error:
Expression.Error: We cannot apply operator < to types Date and DateTime.
Details:
Operator=<
Left=10/5/2022
Right=9/22/2022 12:00:00 AM
Try this
if [TENTATIVE REMOVAL DATE] <= DateTime.LocalNow() then Date.AddDays(DateTime.LocalNow(),1) else [TENTATIVE REMOVAL DATE]
