Export to excel changes the date to text format

[vivek_niti]

Hi,

Having an issue with send to excel option.

The date column in report is in the format (DD-MM-YYYY), but when the data is being exported to excel the all the dates get converted to text. This is not limited to any one report or application, it is happening to all the applications and has started happening from yesterday and no settings has been changed on the server.

Even when exporting the date values of a list box the data is getting converted to text format.

Woking on QV11 SR2.

Early response is appreciated!

Regards,

[amit_saini]

Hi,

Try below:

go to properties of  table -> Number->Select the particular field which comes in text->select date and give required format.

or

=date#(<date filed>,'DD/MM/YYYY')

or

=date(date#(<date filed>,'DD/MM/YYYY'),<Formt code>)

or

copy Full Table option and  paste it excel

Thanks,

AS

[Anonymous]

Awesome! This Works. Sometimes I struggle to find the options!

[FakeJupiter]

This is a really good answer, been using qlikview for some time know, didn't even think of looking in document properties for fixing that.