split from one date to several dates

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

hi there. this is the situation, i'm trying to split one date in several
dates, for example:

01/03/2010 ----- split in 60 dates with the interval of 1 month

01/04/2010
01/05/2010
etc...

60 times...

Can you help me???

Tks in advance...
 
Peter

First, be aware that Access does date/times in US format ... I'm assuming
your list of dates are the 1st of March, the 1st of April, ...

If you want an Access table with the first day of each month for the next 60
months, there's a simple trick. Open Excel, put in a few dates, then extend
the range until you have all 60 (do this "down" rather than "across").

Now open Access and point to that Excel file. Import it.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
tku for ur answer. i knew that all ready with excel, also u can do it in a
access table, i think, but i thought thta i could do it with a query, in an
automatic way...

but, tks anyway...
best regards,
 
Create a table named CountNumber with field CountNUM containing numbers 0
(zero) through your maximum (you said 60 but make it 100).
SELECT DateAdd("m", CountNUM, CVDate([Enter start date])) AS Date_List
FROM CountNumber
WHERE CountNUM Between 0 AND [Enter number of dates];
 
Back
Top