pulling dates between dates

[bholiday]

I would like to automatically get a selected number of dates between a start and an ending date. For example if my start date is 6/01/02 my end date is 9/1/02 and I would like 2 dates to be pulled the result should be 7/1/02 and 8/1/02. I have milled over this for a while, however I am not very good with date functions.
Thanks in advance

 

[antomack]

Check the following post:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32050

 

[bholiday]

reply

I looked at all post you pointed me to. It was helpful but not quite what I had in mind. I want the system to divide the days between the start and end date (ex 120 days) by the number of dates I would like (ex 2 dates) then give me those dates. So if I start on 6/1/02 and end on 9/1/02 the two dates would be between those dates.