help with dates

  • Thread starter Thread starter beginner
  • Start date Start date
B

beginner

hello,

ive created an access database and i want to retrieve records between a
start [which will be entered manually] and 90days.
 
Create a query that returns all of the fields you want.

In the criteria cell under the date field in query, put

Between [Start Date (mm/dd/yyyy)] And DateAdd("d", 90, [Start Date
(mm/dd/yyyy)])

Make sure [Start Date (mm/dd/yyyy)] is typed identically in both cases
(copy-and-paste is a good idea)

Note that even if your regional settings are set to dd/mm/yyyy, you must use
mm/dd/yyyy format (or an unambiguous format such as yyyy-mm-dd or dd mmm
yyyy)
 
hello Doug and Ken,

Thanks a million for your help, it works.

ps: ive been battling for weeks now.

Douglas J. Steele said:
Create a query that returns all of the fields you want.

In the criteria cell under the date field in query, put

Between [Start Date (mm/dd/yyyy)] And DateAdd("d", 90, [Start Date
(mm/dd/yyyy)])

Make sure [Start Date (mm/dd/yyyy)] is typed identically in both cases
(copy-and-paste is a good idea)

Note that even if your regional settings are set to dd/mm/yyyy, you must use
mm/dd/yyyy format (or an unambiguous format such as yyyy-mm-dd or dd mmm
yyyy)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


beginner said:
hello,

ive created an access database and i want to retrieve records between a
start [which will be entered manually] and 90days.
Click to expand...
Click to expand...
 
Back
Top