Need help on date changing format

[KommulaRahul]

 My dropped date is in the above format. 

I want my dropped date to be in MM-DD-YY format. 

Can u write a suitable expression to this

[LRuCelver]

Date - script and chart function | Qlik Sense on Windows Help

[F_B]

Hi KommulaRahul,

your Dropped Date field looks like a timestamp. If you load it as a date field instead, it should take the date format set in the main section of the load editor.

To do this just use the Date() function: Date - script and chart function | Qlik Sense on Windows Help

Something like the following.

YourTable:

LOAD

Date(Dropped Date)

Hope this helps.

[salmankojar · Accepted solution]

hi, @KommulaRahul Just use below expression for your date,
DATE(Dropped Date,'MM-DD-YY')

This will solve your problem.
Thankyou

[nafishkhan]

Hi @KommulaRahul use below 

Date(Floor([Dropped Date]),'MM-DD-YY')  As New_Dropped_Date