Forum Discussion

young351's avatar
young351
Frequent Visitor
3 years ago
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/ tomorr...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    Try this 

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

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

Try this 

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

young351's avatar
young351
Frequent Visitor
3 years ago

That worked!  Thank you so much!