When you export an excel from customer invoiced sales you will get the invoice dates as 01-01-1900 | IFS Community

When you export an excel from customer invoiced sales you will get the invoice dates as 01-01-1900


Userlevel 7
Badge +12

IFS client specifies the Date fields as Date() function so that the dates are formatted properly related to the user's Date formats.

However, due to how Excel works it's disabling evaluation of functions (formulas) by default in protected mode. That's why you see the Date value shown incorrectly when first opening the Excel.

But if you click on Enable Editing then the functions are evaluated and the correct value is shown.

 


0 replies

Be the first to reply!

Reply