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


Userlevel 7
Badge +14

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.

 


2 replies

Userlevel 1
Badge +2

@Chamaka Wimalarathne , I have a question why some date fields are directly view in the correct date format in some other pages even in the protected mode?

 

~Waseem~

Userlevel 1
Badge +2

PLUS Dates are represented as different format in excel as formulae format and normal String format. It can crosscheck with the Formula bar.

Reply