Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi, @KommulaRahul Just use below expression for your date,
DATE(Dropped Date,'MM-DD-YY')
This will solve your problem.
Thankyou
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.
hi, @KommulaRahul Just use below expression for your date,
DATE(Dropped Date,'MM-DD-YY')
This will solve your problem.
Thankyou
Hi @KommulaRahul use below
Date(Floor([Dropped Date]),'MM-DD-YY') As New_Dropped_Date