Kayleigh
Member
- Local time
- Today, 04:00
- Joined
- Sep 24, 2020
- Messages
- 706
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.
This is the formula: =DATE(YEAR(U14) + 3, MONTH(U14), DAY(U14))
U14 would be fldDBSIssueDate in Access.