Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Converting dates in Qliksense

Hello All,

I have below date :-

Aspiring_Developer_0-1649848342662.png

I wish to convert it into dd/mm/yyyy format .

I have tried below :-

MONTHname(Date#(ISSUE_CLOSED_DATE,'DD/MM/YYYY')) as ISSUE_CLOSED_DATE_test

But it giving me blank results. I am assuming that it is varchar format , so i tried to convert it into number using num function , however it didn't work.

Can anyone please help ?

 

 

Labels (2)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Date(Date#(ISSUE_CLOSED_DATE,'DD-MMM-YYYY'),'DD/MM/YYYY') as ISSUE_CLOSED_DATE

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

View solution in original post

1 Reply
hic
Former Employee
Former Employee

Date(Date#(ISSUE_CLOSED_DATE,'DD-MMM-YYYY'),'DD/MM/YYYY') as ISSUE_CLOSED_DATE

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