date grouping

[RD137]

How to retrieve the reports that has been generated between two given dates using a formula? Yhis has been asked in an interview? Kindly give me the solution

 

[JustineB]

Please will you explain again what you are trying to do. I am unsure.
If you are trying to retrieve data between 2 given dates, that is easy by using parameters or formulas. If you elaborate I will try and help.
Justine.

 

[FoxG]

Hi,

One way is to create two date parameters
eg. from_date and to_date

Then add something like the following to the record selection formula.

((datefield} >= {?from_date} and {datefield} <= {?to_date})


Alternatively, you may be able to use one of the predefined date-range functions

Geoff