Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Date convertion to DD/MM/YYYY format

Hi Experts,

Can any one please help me to convert the below Date field into DD/MM/YYYY format it contains the MM/DD/YYYY and number format records like below.

Date.png

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date

View solution in original post

4 Replies
arulsettu
Master III
Master III

try like this

Date(Datte_field,DD/MM/YYYY) as date

anat
Specialist II
Specialist II

date#(date(dt,'MM/DD/YYYY'),'MM/DD/YYYY')
try above method
anat
Specialist II
Specialist II

date#(date#(date(date(num(dt),'MM/DD/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY')
sunny_talwar

May be try this

Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date