Formula for dynamic dates

Question

Hi!

I have a data set with a number of columns containing various dates. I want to create a formula which nulls any dates with are more than 3 years old. The workflow will run regularly so the formula needs to be dynamic. How would I do this please?

Many thanks,

Hannah

aatalai · Accepted Answer

@HannahSwain7  try this conditional formula

If  [datefield] < datetimeadd(datetimenow(),-3,"year") then null() else [datefield] endif