I need to add a formula to my report that informs the end-user what date range the report is reporting for. ex. 20Mar2003 - 20Mar2003. Generally, all reports for the 20th get run early in the morning on the 21st. So my thinking is to use the Special Field 'DataDate' and subtract one day from it. This would remain static then right? What I mean is, if the report were to be opened 3 months down the road the field would still show the value 20Mar2003 even though it's June. Does anyone know of another way of getting these date values?
Secondly, when I try to create a function using the DataDate I get a message saying that "This function cannot be used within a custom function". Help...anyone???
Secondly, when I try to create a function using the DataDate I get a message saying that "This function cannot be used within a custom function". Help...anyone???