topic Re: Show Date text String in Date Format in QlikView

Show Date text String in Date Format

ZoeM — Sat, 16 Nov 2024 20:25:06 GMT

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.

Re: Show Date text String in Date Format

dplr-rn — Fri, 19 Jul 2019 15:57:10 GMT

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')

Re: Show Date text String in Date Format

ZoeM — Fri, 19 Jul 2019 16:09:25 GMT

Excellent!

Thanks Dilipranjith!

Have a good weekend

Re: Show Date text String in Date Format

sergio0592 — Fri, 19 Jul 2019 21:16:41 GMT

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

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