Show Date text String in Date Format

[ZoeM]

Hello Community.

I have a date field coming into the dashboard as a string in the format 2018-10-10 and I would like to change it to 10-Jan-2018.

I ave tried Date(Date#( YourField, 'DD-MMM-YY')'DD-MMM-YY') , Date#(text[, format]) and I cant seem to get it to work.

Any advice?

Thanks team. 

[dplr-rn · Accepted solution]

the format inside the Date# should be the format of the source data
e.g. (guessing its YYYY-MM-DD)
Date(Date#( YourField, 'YYYY-MM-DD'),'DD-MMM-YYYY')

[ZoeM]

Excellent!

Thanks Dilipranjith!

Have a good weekend

[sergio0592]

Hi, In addition, about interpretation function, take a look here

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157