topic Re: Convert data loaded in numeric format to Date in QlikView

Convert data loaded in numeric format to Date

Thu, 04 Jun 2015 10:34:12 GMT

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

MK_QSL — Thu, 04 Jun 2015 10:35:44 GMT

Date(YourDateFIedl) as YourDateField

Thu, 04 Jun 2015 10:37:26 GMT

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 — Thu, 04 Jun 2015 10:38:01 GMT

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.

Gabriel — Thu, 04 Jun 2015 10:38:21 GMT

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 — Thu, 04 Jun 2015 10:48:15 GMT

Try like this

Load *,

Date(YourDateFIedl) as YourDateField

From datasource;