Date formatting in load script not working

[SriGouri]

Hi !

I am new to qliksense and I am learning data load scripting. I have been trying to load a date column in mm/dd/yyyy format using the following script line

LOAD
Date("Date",'mm/dd/yyyy') as "Date",

But I am getting  00/mm/yyyy as the output. dd part of the format is beins set to 0 and it is not detecting any of the dates. Can anyone please help me with this?

(Attaching a snippet of the resulting table for easier understanding)

Thanks!

[tresesco]

'm' indicates minute and 'M' indicates month. Hence try like :

Date("Date",'MM/dd/yyyy') as "Date",

[Chanty4u]

What is input date format ?  can you tell.

for better understanding  check below link .

https://ezdatamunch.com/use-simple-date-functions-qlikview-qliksense/

[SriGouri]

Thank you so much tresesco. This worked!!

[SriGouri]

Thanks for the inputs Chanty4u. The data format in the input file is short-date(in excel). The issue was i was using mm/dd/yyyy instead of MM/dd/yyyy. So the format was taking minutes instead of months. I could fix the issue by changing mm to MM.