PRE-DEFINED DATE RANGE 1

[reidtw]

Hi, had difficulty working this out, wonder if anyone can help...

I'm using cr8 to a sql w2k database.

I would like to hard code the date range so that the previous 18 months of data automatically renders based on a particular data field.

For instance, I refresh the report on any day in July 2006 and the previous 18 months data is chosen, i.e 1st of Jan 2005 to 30th Jun 2006; in the next month I run the report and the data for 1st feb 2005 to 31 Jul 2006 is rendered, and so on.

I was trying to use dateserial but it isn't worth showing you what I did!

Any help would be appreciated.

 

[lbass]

You should be able to use:

{table.date} in dateserial(year(currentdate-day(currentdate)),month(currentdate-day(currentdate))-17,1) to
dateserial(year(currentdate-day(currentdate)),month(currentdate-day(currentdate))+1,1)-1

-LB

 

[reidtw]

lbass,

Perfect!

Is there any documentation you know of that actually explains generically what each part of the formula is doing, as the cr help is vague, so I can understand it!

Thanks
T

 

[lbass]

Currentdate-day(currentdate) returns the last day of the previous month. In the second half of the formula, adding one month returns the first day of the next month, and then subtracting 1 from that returns the last day of the previous month.

-LB