Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It does if your qlik date format is the same of your excel (windows) date format, otherways it is a string
Hope it helps
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 ??
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
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