Formula for dynamic dates

[HannahSwain7]

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 solution]

@HannahSwain7  try this conditional formula

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

[Deano478]

Hey @HannahSwain7 can you throw some sample dates in here so we can test on them?