topic Re: Help set date format on script in QlikView

Help set date format on script

silvia_assuncao — Mon, 13 Aug 2018 14:35:45 GMT

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

Re: Help set date format on script

olivierrobin — Mon, 13 Aug 2018 15:05:57 GMT

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

Re: Help set date format on script

m_woolf — Mon, 13 Aug 2018 15:17:51 GMT

See the attached qvw.

Re: Help set date format on script

olivierrobin — Mon, 13 Aug 2018 15:21:08 GMT

date is considered as a string

in listbox,

General

replace you field with <Expression> and use

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

Re: Help set date format on script

silvia_assuncao — Mon, 13 Aug 2018 16:18:27 GMT

Thanks guys!

Re: Help set date format on script

olivierrobin — Tue, 14 Aug 2018 06:51:34 GMT

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