Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to change a date field date format?

Hi guys,

When loaded to the qvw - my date field data has convert to 10OCT2018.

I want to change the date format to 10/10/2018, how to change it?

i have tried on this formula, but the result came out was empty, nothing is out.

date(date#(my_date,'ddmmmyyyy'),'dd-mmm-yyyy') as my_date1.

Which part is wrong???

Rgds,

Jim Chan

1 Solution

Accepted Solutions
sunny_talwar

Try this may be

date(date#(my_date, 'ddMMMyyyy'), 'dd/MM/yyyy') as my_date1

View solution in original post

7 Replies
sunny_talwar

Try this may be

date(date#(my_date, 'ddMMMyyyy'), 'dd/MM/yyyy') as my_date1

jim_chan
Specialist
Specialist
Author

Sunny, Thanks again! long time no see! if you still remember me

haha

jaumecf23
Creator III
Creator III

Hi,

Try this:

=date(date#(my_date,'ddMMMyyyy'),'dd/MM/yyyy')

jim_chan
Specialist
Specialist
Author

Sunny,

I have another file - but date format is as below, it has timestamp as well, so how to change it to 10/10/2018?

date data as this: 10OCT2018:15:37:56

sunny_talwar

Try this

Date(Floor(Date#(DateField, 'DDMMMYYYY:hh:mm:ss')), 'DD/MM/YYYY') as DateField

jim_chan
Specialist
Specialist
Author

thanks bro, i will try it out, then let u know bro!

jim_chan
Specialist
Specialist
Author

Bro.! Its correct! thanks!