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.

[suvechha_b]

tried but not working

[sibideepak]

Hi,

Sometimes some extra spaces in the excel cause this problem,

so when you're loading script try,

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

[#4]

You can try at script level like below & use below field in table,

date([Start Date],'dd-mm-yyyy') as New_Start_Date

& let me know what is the output?

[suvechha_b]

See the excel file image

In excel I formated it in DD/MM/YYY format . it is showing on excel file but when I select it the value is showing "2015/02/23 "

[suvechha_b]

When I am using trim I am getting the value correct: "23/02/2015"

But all the other dates are not pulling , they are blank

[vardhancse]

Once check the default date format in the script editor.

SET DateFormat='DD/MM/YYYY';

Or else in the chart/table where you are seeing the Start date field once check the number format in properties->number<tab>

select Start date->Date

[settu_periasamy]

Hi,

Can you try the below attached excel? i formatted the Start Date and End End using the Text to columns.

Just try this.

[senpradip007]

Have a look on this.

[#10]

Hi

do following changes in excel it works,

1) change all start Date custom format to dd/mm/yyyy by selecting each cell value.

In your script do single change like below,

SET DateFormat='DD/MM/YYYY';

& Take [Start Date] field to check resulted field.

[suvechha_b]

Can any one help me how to write in expression level.

As I dont want to change the script of qlikview.

Is going to affect other calculation.