Hi, is there a simple way to convert the US date: YYYYMMDD in european format: DDMMYY?
if it is of datatype DATE inside Navision check the format property of the displaying form.
Michael, YYYYMMDD IS NOT as in isn’t as in never was the US date format. US Date format is MMDDYYYY. YYYYMMDD is navisions internal format for string dates, and is logical since it is required for sorting purposes. If you want to display the date in European format, or use it in a data port, you can set the format properties on the field to do this. Open and form with a date field, click on the date fiel, open properties, find FORMAT, and press F1. The help information there is very clear. note that there are two types of format, the property and the function, and you need to read the help for both. I think this should get you what you want. good luck.