Skip to main content

If DateCreated is =< Today (+30 days), "Retire"

  • June 24, 2022
  • 1 reply
  • 8 views

Forum|alt.badge.img+3

Hi could I get some help. I’m going nowhere with IFs and the Date/Time functions.

How do I get make this work to print a result if the DateCreated is 30+ days older than TODAY()

Driving me mad
thanks

1 reply

Forum|alt.badge.img+3
  • Author
  • New Participant
  • 3 replies
  • June 24, 2022

IF({datetime-diff} <-30, “retire”)

made it! nearly killed me.