Get min and max date for date range in date field.

zulq
zulq Member Posts: 204
Hi,
I have a report which has date required filter field. Sometimes users do enter date in range form i.e. 01/01/09..31/01/09
Now I want to be able to display in the report the minimum date i.e. 01/01/09 and the maximum date i.e. 31/01/09
Any ideas how to get this within the report.


Thanks.
Few years ago we were not existing and few years to come we would be in the grave! So what will benefit us in the grave?

Comments

  • ara3n
    ara3n Member Posts: 9,258
    use the following functions.
    StartDate := Record.GETRANGEMIN("Date Filter");
    EndDate := "Record.GETRANGEMAX("Date Filter");
    
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n