how to pull the Maximum and Minimum Start date and End date

[compu]

Hi everyone

i would like to know if it is possible to pull the max and min start date and end date.

basically i have an option where by the user selects the desired date range that they would like.

now i would like to know how to get the earliest and latest date range should they not select a date range.

N.B my date range is being displayed at the top of my report.

i have researched this and still nothing has come up.

please help :banghead:

 

[Isskint]

You would use the 2 functions Dmax() and Dmin(). The syntax is like;

Dmax("[DateField]", "[TableName]")
Dmin("[DateField]", "[TableName]")