Date conversion

Bokk

Is there a way to convert a String to a Date? I want to check some files based on the date entered by the user in the request form - I can retrieve it using GETFILTER, but this function returns a String which can't be used to filter a date field.

Also, I have a report that shows timesheet information for each employee in their own batch. I have set the PRINTONLYIFDETAIL property to YES. Generally if there are not details, an employee's timesheet will not print, except for the first employee (batch). The first one prints even if there are no details, after that it is fine. Any ideas?

Thanks,
Shelley

Sbhat

Hi Shelly,

You could use the EVALUATE function to convert a string to date. See EVALUATE help in Navision. Also in the report print what you could do is onPReSection on the sections do a setrange for the condition and if you dont find any records matching the setrange then CURRReport.showoutput = FALSE. This will substitute for Printonlyifdetails.

Thanks

Best regards
Suresh
NY.