Skip to main content

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


Chamaka Wimalarathne
Hero (Partner)
Forum|alt.badge.img+15

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

mwaseem
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 8 replies
  • October 4, 2022

@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~


mwaseem
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 8 replies
  • October 6, 2022

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings