Trouble with Chinese Dates

atankersley

My company has an office in China. The date format there is yy/mm/dd.
When they enter a date into the my date filter textbox on a report the report still picks up the last two digits as the year. If they enter the date as mm/dd/yy navision give an invaled date error. Is there any way in code to parse the Chinese date format into mm/dd/yy and then use it with the report.

ara3n

Change their local setting to chinese. That way everything (dates, integer) etc will be formated to that local setting.

In regards to how to parse the date to a string.

Use DATE2DMY to get the day, month and year.

Alex_Chow

What ara3n is talking about is changing the Windows Regional Settings to whatever you want it to be.

Navision uses the regional settings of the local computer.