Adding 1 year and two weeks to a date field

GemmaM

I have an end Date field where I need to calculate whether this is more than 1 year and two weeks after a Start date field.

Example:

Start date = "2017-09-01" - their 1 year anniversary date is "2018-09-01"

End date = "2018-09-15" - flag this as it's more than 2 weeks after their anniversary date.

Can this be done in one formula?

thibaut

Hi,

I would add a new field with something like that : 

if DateTimeAdd(DateTimeAdd([START_DTE],1,"year"), 14, "days") > [END_DTE] then 1 else 0 endif