I want to set up a report to execute the first day of the month in which the date criteria will be based on the previous month. For example on September 1, 2008 I want to execute a report which will extract data from August 1, 2008 thru August 31, 2008 (previous month)without any manual intervention. I will set up the report in ReportCaster and it will automatically execute on the First of every month. I know there is a way but I cannot find any date documentation pertaining to this. I know other languages (i.e. Crystal) have functions that pertain to "Last full week", "Last Year", "Last Month", "Last 90 days" etc... Thanks A Million, all!

First - before Ginny asks you to - Update your signature to let us know what platform, suite you are using.

Second - RC can be set to kick off on the first of each month (Make sure that is what you want)

Third - there is a plethora of date functions in WF. One will allow you to subtract one from the current month to get the prior month and another to select BOM beginning of the month and EOM end of the month.

You can find these in the functions manual, the help facility in the product you are using, or search the technical documentation library which is accessible from the upper right of this screen.

This message has been edited. Last edited by: jimster06,

Search for AYM and AYMD

Denny

You have functions available like actual date (&YYMD). And from that starting point it's rather easy to go to the former month begin and enddate.
It also depends on the internal format of your date, that might give you the possibility to sat something like
WHERE MONTH EQ '200808'