Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date(YourDateFIedl) as YourDateField
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
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.
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
Hi
Try like this
Load *,
Date(YourDateFIedl) as YourDateField
From datasource;