date expired in a year

[Guest]

I have a 2 date field, if I enter date e.g. 01/01/05 in one date field on
entry of 2nd date field can I have it populate 01/01/06, i.e one year

Many thanks

 

[Guest]

got solution, under control source of the field type date+365

 

[Ron Weiner]

What happens on a leap year?? Try ? #1/1/08# + 365 from the immediate window
in Access!! RutRow R'Astro

You might want ro change it to dateadd("yyyy",1,#1/1/08#) This will give
the correct calculation under all conditions.

 

[Guest]

I did, though it gives me default of 01/01/2009 in date field 2 for all dates
entered in date field 1