Query by date

[kdoran]

I have been looking and unable to find out how to run a query that will look at a date field and find dates within a set number of days for example last 30 days or last 365 days from today etc... I am looking to run a report that will generate this and only get the entries from the last (fill in the blank) days.

Any ideas?

Thanks in advance,

Kelly

 

[stix4t2]

Hey Kelly,

Use the the DateAdd() function to return the date relative to another date.

DateAdd(interval, number, date)

 

[SkipVought]

Hi,

between DateField and Date()+FillInTheBlank

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}

 

[PHV]

In fact, in the criteria cell of [Date field]:
Between Date()-(fill in the blank) And Date()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kdoran]

Well I have been trying to get these to work but i do not know sql. and the dateadd does not fit what i want to do as I don't want to add a date but retrieve numerous dates.

I was also looking at 'HAVING () < Date()-365' but not sure how to use?

any ideas, i've been banging my head on this.

Kelly

 

[kdoran]

In fact, in the criteria cell of [Date field]:
Between Date()-(fill in the blank) And Date()
Hope This Helps, PH.

i will try this out

 

[kdoran]

Thanks for the help, my head feels better now (low watt lightbulb inside).

In fact, in the criteria cell of [Date field]:
Between Date()-(fill in the blank) And Date()

worked out great!

Kelly