topic Re: excel date appears as number in QlikView

excel date appears as number

iliaisyah — Thu, 19 Jul 2018 08:15:02 GMT

anyone can assist as my MMM-YY found as number

Re: excel date appears as number

petter — Thu, 19 Jul 2018 16:46:34 GMT

They sometimes do when you get a date from an Excel Workbook sheet. The way to remedy it is to wrap the field name in a Date()-function in the load in your load script to turn it into a real date.

LOAD

.....

Date(YOP) AS YOP,

.....

Re: excel date appears as number

PabloTrevisan — Thu, 19 Jul 2018 17:06:46 GMT

Use function Date with the mask you want .. like this:

Date(YOP,'MMM-YY') as YOP

Re: excel date appears as number

iliaisyah — Fri, 20 Jul 2018 07:13:12 GMT

yes i already load as above and i get my time frame.

Re: excel date appears as number

vvvvvvizard — Fri, 20 Jul 2018 07:28:36 GMT

Date(Date#(YOP)',MMM-YY') AS YOP

Re: excel date appears as number

petter — Fri, 20 Jul 2018 07:34:24 GMT

You can also set the number format on the properties of the list box to "date" to get it shown right.