Date Calculation.,.

[Dragon]

I have a table with the following fields:

FName/Text LName/Text DOB/Date Days/Int
John Smith 01/01/70 14
Jane Dow 03/15/75 10
Erik Jones 03/25/72 10

I would like to get all the records that have a DOB coming up within the
number of days specified in the Days field.

For Example, if I run the query on the data above, I should get the
following:

FName/Text LName/Text DOB/Date Birthday Years
Jane Dow 03/15/75 03/15/2005 30

Any ideas how would I go about it?

Thanks.

 

[Allen Browne]

Try something like this:

DateDiff("d", Date(),
IIf(DateSerial(Year(Date()), Month([DOB]), Day([DOB]) < Date(),
DateSerial(Year(Date())+1, Month([DOB]), Day([DOB]),
DateSerial(Year(Date()), Month([DOB]), Day([DOB]))) < [DaysInt]

 

[Per Larsen]

Maybe somrthing like:

SELECT FName,
LName,
DOB,
DateAdd("yyyy", Year(Date)- Year(DOB), DOB) AS Birthday,
Year(Date)- Year(DOB) AS Years
FROM table
WHERE DateDiff("d", Date(), DateAdd("yyyy", Year(Date)- Year(DOB), DOB)) < Days

hth

PerL

 

[Dragon]

Thank you everyone. I will give it a try

Maybe somrthing like:

SELECT FName, LName, DOB, DateAdd("yyyy", Year(Date)- Year(DOB), DOB) AS
Birthday, Year(Date)- Year(DOB) AS Years
FROM table
WHERE DateDiff("d", Date(), DateAdd("yyyy", Year(Date)- Year(DOB), DOB))
< Days

hth

PerL