Date filter as date range in Report request page

Date filter as date range in Report request page by using String Functions in NAV.

Use ConvertStr to change ‘..’ to ‘,,’. Use SelectStr to trim left and right string from char ‘,’ and get Start date and end date Text string. Add ‘d’ to the strings and use evaluate to con vert to dates.

01012010..01012019.

tempstring := ConverStr(01012010..01012019′,’..’,’,,’);

tempString := SelectStr(tempString,1, ‘,’)

DateStart := tempString + ‘D’;

 

Leave a Reply

Your email address will not be published. Required fields are marked *