Please help how to format date

[suvechha_b]

Facing problem when loading date field from excel file.

Please find the excel file and sample model attached.

The problem is on date format of Start Date  as because my source excel file having start date : 2015/02/23

I have formatted to "dd/mm/yyyy" in excel. But it is showing in excel but pulling wrong data in qlikview.

[vardhancse]

Once check the default date format in script editor

SET DateFormat='MM/DD/YYYY';

[MK_QSL]

Use

=Date([Start Date])

as calculated dimension

[#4]

Hi,

Try like below in caculated dimension,

=date([Start Date],'DD-MM-YYYY')

Then change label

[vardhancse]

Hi,

In script level we can use like

Date(Floor([Start date])) as Start_Date,

Time(Floor([Start date])) as Start_Time

[suvechha_b]

Its not working.

[suvechha_b]

I tried it but its not working

[suvechha_b]

tried but not working

[vardhancse]

Might be issue with the excel data format once try to change in excel sheet and try to relaod

[sibideepak]

Hi suvechha.b,

Sometimes some extra spaces in the excel cause this problem,

so when you're loading script try,

date(trim([Start Date]),'DD-MM-YYYY')