help with dates

[beginner]

hello,

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

 

[Douglas J. Steele]

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)

 

[beginner]

hello Doug and Ken,

Thanks a million for your help, it works.

ps: ive been battling for weeks now.

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)

hello,

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