Increment Date Value

[TaylorTot]

Hello,

I'm working in Crystal v8.5. I have a start date and an end date. I would like to increment the date value by month. Here is an example of what I would like:

Start Date = 1/1/2005
End Date = 4/1/2005

I would like a variable that returns a value for the following:

1/1/2005
2/1/2005
3/1/2005
5/1/2005

I thought I could use the DateAdd function but it isn't working. Can anyone provide any suggestions? Thanks!

 

[damonkimble]

I'm missing how your two start and end dates should return four date values. Also, what was your formula that used dateadd and what were the results?

damon

 

[Madawc]

{your.date}+1 ought to add a day. To do it long-windedly in DateAdd would be DateAdd("d", 1, {your.date}).

Just what did you try that didn't work? It helps to post formulas that are failing.

Also if I were doing it, I'd select data between the two dates, then group them by date.

Also consider using a Crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10