Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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!