Web Development·11,944 discussions

SQL in MS ACCESS : Date handling

Locked

My table (tblStaff) has a date of birth field (DOB) defined as a ‘General Date’.
I need to write a Query that counts those rows where the staff are under 25 years old, at run time. I am new to SQL, so can anybody advise on the syntax please ?
Many Thanks

Topic

Clarifications

In reply to SQL in MS ACCESS : Date handling

Clarifications

SQL in MS ACCESS : Date handling

In reply to SQL in MS ACCESS : Date handling

I have solved this by using this coding :
DateAdd(“yyyy”, 16, DOB) <= Date() & DateAdd("yyyy", 16, DOB) > Date()

Try this

In reply to SQL in MS ACCESS : Date handling

Select Count(*) From Staff Where DateAdd(year,25,DOB) < GetDate() Few other variations But DateAdd, DateSubtract ansd DatePart are along with GetDate() are usually in there somewhere.

SQL in MS ACCESS : Date handling

In reply to Try this

Thanks Tony
I have learned a lot more about dates these last few days !

[Author]

Replies