Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert data loaded in numeric format to Date

Hi All,

I have a column in excel which has values in date format DD/MMM/YYYY.

But when I load it into qlikview, these are loaded into number format.

Is there something which I can do in the script itself for converting it from numeric format to the date format in which it is present in the excel.

Thanks,

Asma

5 Replies
MK_QSL
MVP
MVP

Date(YourDateFIedl) as YourDateField

Not applicable
Author

Hi Asma,

yes, date are stored under numeric value, like today is something like 42159

you can modify this into tab 'numbers' or use a date(Your_Input_Date, 'DD/MM/YYYY')

best regards

Chris

vishsaggi
Champion III
Champion III

Hi Asma,

You can try this:

LOAD Date(Date#(Date_Column, 'DD/MMM/YYYY'), 'DD/MMM/YYYY'), *

FROM .....

If not can you upload your sample data.

V.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

In the script just do this

dataLoad:

LOAD

Field1,

Field2,

Date(DateFieldFromExcel)          AS WhateverName

FROM SourcePath

;

Use Date# if date format in excel is different to how you want to display the date field in UI

MayilVahanan

Hi

Try like this

Load *,

Date(YourDateFIedl) as YourDateField

From datasource;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.