Solved Convert excel formula to expression (1 Viewer)

[Kayleigh]

I have a formula which would add three years to the date in cell. But struggling to convert this to an expression to be used as a conditional formatting rule in Access forms.
This is the formula: =DATE(YEAR(U14) + 3, MONTH(U14), DAY(U14))
U14 would be fldDBSIssueDate in Access.

 

[Pat Hartman]

Replace "U14" with the name of a field.
Replace the Date() function with cDate() and include the correct delimiters.

=cDATE(YEAR(fldDBSIssueDate ) + 3 & "/" & MONTH(fldDBSIssueDate & "/" &, DAY(fldDBSIssueDate ))

 

[arnelgp]

Instead of 4 functions, use only 1:

=DateAdd("yyyy", 3, [fldDBSIssueDate])

 

[Kayleigh]

Both work fab! Thanks