Getting a simple date list

[RichardMGreen]

Hi all

I want to use a simple query to get a list of dates for the last 365 days.
I've tried to create it using a Select query but Access is complaining that I have no table or query selected.

It's straight-forward in SQL as you can do a simple Select without a From.

Anyone any ideas on how this can be done?

 

[Norie]

Richard

How did you try it in Access?

 

[RichardMGreen]

I did a simple select to get date where the date was between today-366 and today.
The SQL was :-
SELECT Date() AS Dates
WHERE (((Date()) Between Now()-366 And Now()));

but it gives me an error because the query doesn't contain a table or another query.

I've used a table full of dates for the time being.

 

[Norie]

Richard

Even if that query had worked it would only have repeated the same date over and over.

Even in 'proper' SQL you can't use a simple SELECT statement to get the dates.

I think some versions do have ways of doing it but most of them seem to use some sort of procedure or other method.

I have seen some examples using what appears to be very advanced SQL but I think they also use some database-specific methods.

When I need this sort of thing I just goto Excel to create the dates and copy them to Access.

Not ideal but it works.

 

[RichardMGreen]

I've created a table to use for the time being and future proofed it for a few years.
I just wondered if I was going wrong somewhere.

Thanks for your time anyway.

 

[HiTechCoach]

I've created a table to use for the time being and future proofed it for a few years.
I just wondered if I was going wrong somewhere.

Thanks for your time anyway.

Richard,

I have an example that may be what you want.

See: Generate a list of dates in a year