Send to excel option

[#1]

I'm trying to export a straight table into excel by clicking on "Send to excel" option. While exporting

date field is taken as string in excel. Is there any way to control it and export it as Date field.

Thanks

[alexandros17]

It does if your qlik date format is the same of your excel (windows) date format, otherways it is a string

Hope it helps

[#3]

Hi Alessandro,

Thanks for the reply.

The qlikview file that is being developed will be used by different people at different part of the world and each of them will be having their own date format set on their machine. We cannot put restriction on them to set their system format to what we want.

Is there any other way to get date in date format instead of string while exporting to excel using "Send to excel" option ??

[alexandros17]

It's only an idea ...

use 3 fields in the source xls:

Year, Month, Day, in this way all excel files will have the same format and loading these data into qlikview will need only the makedate(year, month, day) function, in this way all dates will have the same format

[#5]

Yes,  and if you don't want to provoke this format you may build your own after the orginal like

if string looks like 21/06/20014

makedate(left(date,4), mid(date, 4, 2), right(date, 2)

best regards

Chris