I have two date fields, when a user enters a date in datefield1 (dd/MM/YYY) eg 20/11/2024 I want the date in datefield2 to add 3 years to that date and show 20/11/202027. I have tried dateAdd(StartDate, "M", 36) but date add isn't a valid function

I have two date fields, when a user enters a date in datefield1 (dd/MM/YYY) eg 20/11/2024 I want the date in datefield2 to add 3 years to that date and show 20/11/202027. I have tried dateAdd(StartDate, "M", 36) but date add isn't a valid function

• infopath

Share Improve this question Follow edited Nov 20, 2024 at 11:37 Yevhen Horbunkov 15.6k33 gold badges2626 silver badges4545 bronze badges asked Nov 20, 2024 at 11:25 sql2015sql2015 61133 gold badges1717 silver badges3636 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You're on the right track. Adding years is this format:

datefield1.AddYears(3) 

It's a blind add of 3 years though & has caused me some issues in the past with accuracy I needed.

Keep leap years in mind because 2/29/2024 + 3 years won't give the same date.