Query Dates

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

Guest

I am trying to have my query calculate a date from "Training" date add 12
months or 1 year to get my "Annual Training" date. Example one individual
received "training" on 5 Feb 05 I need the query to add one year and place it
in "Annual Training" to give me an answer of 5 Feb 06.
 
Hi,
have a look at the DateAdd function:

=DateAdd("yyyy",1,[YourDateField[)
OR
=DateAdd("m",+12,[YourDateField[)

HTH
Good luck
 
Try DateAdd

dateadd(FieldName,1,date())

Select training, dateadd(training,1,date()) As [Annual Training] From
TableName
 
Sorry I mixed up the names

Try DateAdd

dateadd("yyyy",1,FieldName)

Select training, dateadd("yyyy",1,training) As [Annual Training] From
TableName
--
\\// Live Long and Prosper \\//


Ofer said:
Try DateAdd

dateadd(FieldName,1,date())

Select training, dateadd(training,1,date()) As [Annual Training] From
TableName

--
\\// Live Long and Prosper \\//


Robb @ FLW said:
I am trying to have my query calculate a date from "Training" date add 12
months or 1 year to get my "Annual Training" date. Example one individual
received "training" on 5 Feb 05 I need the query to add one year and place it
in "Annual Training" to give me an answer of 5 Feb 06.
Click to expand...
Click to expand...
 
Back
Top