Date Issue

[Vikash2024]

This is the date format in Excel sheet 

09-12-2024
10-12-2024
11-11-2024
11-12-2024
12-11-2024
12-12-2024
02-12-2024
03-12-2024
04-11-2024
04-12-2024
05-11-2024
05-12-2024
06-11-2024
07-11-2024
08-11-2024

But while loading the sheet in Qlik Sense Date format automatically changed

12-09-2024
12-10-2024
11-11-2024
12-11-2024
11-12-2024
12-12-2024
12-02-2024
12-03-2024
11-04-2024
12-04-2024
11-05-2024
12-05-2024
11-06-2024
11-07-2024
11-08-2024
11-11-2024
11-12-2024

I want to exact format of excel sheet in Qlik how to get this ?
Below i also uploaded the image to get clarity regarding the date problem.

[Padma123]

1-method

change the date format as 

SET DateFormat='M/D/YYYY';

2-METHOD

use 

DATE("date",'M/D/YYYY') AS "date"

[Mandy]

Or you can try changing the setting on the Main section to the date time format you require

SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

You may also need to check the settings on 

SET CollationLocale='en-GB'; is set to your requirements, it can default to en-US

[kaushi2020]

you can set the date either in load editor or via the expression in the sheet option. 

I have done personally in sheet as per below. consider my date column in MyDate. 

Date(MyDate,'DD-MMM-YYYY'). text between the quotes -- 'DD-MMM-YYYY' you can change to any format. This way you can retain the date format same as the excel. 

[Vikash2024]

I tried but still not able do it.... I am sharing you two images one is while uploading the file and other one it after implementing the solution.

[Vikash2024]

I tried but still not able do it.... I am sharing you two images one is while uploading the file and other one it after implementing the solution.

[Mandy]

So neither option has worked for you. What does your Load Script look like? Or did you make changes in the Chart Script?

[JandreKillianRIC]

Hi @Vikash2024 

In the back end (Script load editor) 

Load the date using the following

Load 

xx, 

xxxx, 

xxxxx, 

Date( Date#( YourDateField, 'DD-MM-YYYY'), 'DD-MM-YYYY') as FormattedDate
From .... 

Regards - Jandre

[Vikash2024]

I implement the solution that provided . above i am shared the image of implementing the solution. check it once please.