Custom Column to Replace Date Using "If"

[young351]

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

[jgeddes · Accepted solution]

Try this 

if [TENTATIVE REMOVAL DATE] <= DateTime.LocalNow() then Date.AddDays(DateTime.LocalNow(),1) else [TENTATIVE REMOVAL DATE]

[young351]

That worked!  Thank you so much!