Date Formula

[Guest]

This is probably a simple question. I have a date field with a formula
"=[hiredate] + 365*2 (I want to add exactly 2 yrs from hiredate). The problem
is, for some of my records the formulated date is exactly 2 years from the
hire date, which is what i want, and some dates are 1 day off. I think this
is because of a leap year or something. I also need to calculate a hiredate +
15 months which also gives me the same problem sometimes. If someone could
help me i would appreciate it,
Thanks

 

[Guest]

Use the DateAdd function to do it for you

=DateAdd("yyyy",2,[hiredate]) ' To add two Years
=DateAdd("m",15,[hiredate]) ' To add 15 months to the date

 

[Guest]

I think you should try using the dateadd function. Try this:

=DateAdd("yyyy", 1, [hiredate])-1 and <= DateAdd("yyyy", 1, [hiredate])=+1

This is probably a simple question. I have a date field with a formula
"=[hiredate] + 365*2 (I want to add exactly 2 yrs from hiredate). The problem
is, for some of my records the formulated date is exactly 2 years from the
hire date, which is what i want, and some dates are 1 day off. I think this
is because of a leap year or something. I also need to calculate a hiredate +
15 months which also gives me the same problem sometimes. If someone could
help me i would appreciate it,
Thanks

 

[Guest]

Thats what I needed, Thank you both

I think you should try using the dateadd function. Try this:

=DateAdd("yyyy", 1, [hiredate])-1 and <= DateAdd("yyyy", 1, [hiredate])=+1

This is probably a simple question. I have a date field with a formula
"=[hiredate] + 365*2 (I want to add exactly 2 yrs from hiredate). The problem
is, for some of my records the formulated date is exactly 2 years from the
hire date, which is what i want, and some dates are 1 day off. I think this
is because of a leap year or something. I also need to calculate a hiredate +
15 months which also gives me the same problem sometimes. If someone could
help me i would appreciate it,
Thanks