Help set date format on script

[silvia_assuncao]

Hi,

I'm connecting Qlikview to a spreadsheet and I have many columns with dates, and for this columns I've created a cross table so that I can have a only field with multiple dates. but I'm having some trouble when showing this dates, because they do not show as dates standards, they are showing as numbers instead. could someone help me solve this and have it show as dates?

thanks

[olivierrobin]

hello

the numbers are the internal representation of date in excel (and qlik also)

in your list box, got to Number, and chose Date format

[m_woolf]

See the attached qvw.

[olivierrobin]

date is considered as a string

in listbox,

General

replace you field with <Expression> and use

=date(num#(Date),'D/M/YYYY')

[silvia_assuncao]

Thanks guys!

[olivierrobin]

don't forget to close the thread and mark responses as correct