Date query

[simon4amiee]

How do I return data to show the next 30 days from todays date

 

[MSAccessRookie]

How do I return data to show the next 30 days from todays date

Try using the DateAdd()( Function and see if thatgets you what you are looking for.

    DateAdd ( 
        interval, { "d"=Days, etc. }
        number,  { Number of { Intervals } to add }
        date { Starting Date }
        )
 
   DateAdd ( interval, number, date )

 

[JANR]

By setting a Where clause on a date field to Date()+30 should do it.

no was a bit quick there, dateadd function is the way.

JR

 

[simon4amiee]

DateAdd ( interval, number, date ) seems ok but specifically i need to show all dates 30 days from current date (todays date), so that when i run the report I get all records that are coming up!

 

[MSAccessRookie]

By setting a Where clause on a date field to Date()+30 should do it.

no was a bit quick there, dateadd function is the way.

JR

I believe that either one will resolve the Ops issue, since the original issue was regarsing adding a specific number of days. The main advantage to the DateAdd() Function, is that it provides the flexibility of having intervals other than days.

 

[MSAccessRookie]

DateAdd ( interval, number, date ) seems ok but specifically i need to show all dates 30 days from current date (todays date), so that when i run the report I get all records that are coming up!

You already know the Start Date, and DateAdd() can get you the End Date. The SQL Between Function can be used to select records that are in the range that you want.

 

[simon4amiee]

whats the critera then??

 

[JANR]

you could try this in the criteria of your datefield.

Between (Date()) AND (Date()+30)

It will give you records from today and 30 days ahead.

JR

 

[MSAccessRookie]

whats the critera then??

Between StartDate And EndDate (Calculated using DateAdd())

 

[Insane_ai]

Criteria: >=Date()+30