Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
iliaisyah
Contributor III
Contributor III

excel date appears as number

anyone can assist as my MMM-YY found as number 1111.png

2222.png

1 Solution

Accepted Solutions
petter
MVP
MVP

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,

    .....

View solution in original post

5 Replies
petter
MVP
MVP

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,

    .....

View solution in original post

PabloTrevisan
Partner
Partner

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

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

iliaisyah
Contributor III
Contributor III
Author

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

vvvvvvizard
Specialist
Specialist

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

petter
MVP
MVP

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