Date format not coming proper while exporting to excel from straight table chart

[saivina2920]

I am using below expression in my qlikview chart straight table.

Dimensions

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) , EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE) , EMP_RELIEVE_DATE))

Expressions

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]) , Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]) , EMP_RELIEVE_DATE))

While exporting into excel, the date format coming as "42301","45219",etc,

Is there anything need to change the format in dimensions or expressions...?

[Frank_Hartmann · Accepted solution]

Did you activate the date format for your expression?

[saivina2920]

Thanks..It's working