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

zulqzulq 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

  • ara3nara3n Member Posts: 9,256
    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
Sign In or Register to comment.