Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ZoeM
Contributor II

Show Date text String in Date Format

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. 

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Show Date text String in Date Format

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')
3 Replies
Partner
Partner

Re: Show Date text String in Date Format

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
Contributor II

Re: Show Date text String in Date Format

Excellent!

Thanks Dilipranjith!

 

Have a good weekend

sergio0592
Valued Contributor II

Re: Show Date text String in Date Format

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

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