Skip to main content

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.

 

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

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

Reply


Terms & ConditionsCookie settings