Calculate date in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a end date for my soldier's service eligability. We need to request
extentions 90 days out. I have a field for the date to have request done
tried to do an update query to that field with = DateAdd (DD, -90, EndDate) I
get a general type conversion failure message. If I change the days to years
and have either negative of positive numbers it works.

Any ideas on how to calculate dates based on days instead of years?

Thanks and give yourself an "ATTA-BOY (GIRL)" for helping your country. :)
 
Ha ha ha. Wish it was that easy. As we will be stateside we feel much
luckier and safer than a lot of other Soldiers are currently.
 
It worked!! Thanks a bunch. For some reason I thought I needed two Ds to
indicate the day. I know it was probably second nature for you but I am much
appreciative for the help.



[email protected] said:
You should be able to do this.

Try DateAdd("d",-90,[enddate])
-----Original Message-----
Can't be done. Bring them home.


eligability. We need to
request DateAdd (DD, -90,
EndDate) I change the days to
years helping your country. :)


.
Click to expand...
Click to expand...
 
Back
Top