Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jagjivvt
Creator
Creator

Date conversion

How do i change this date format 3/12/2012 2:09:54 PM to 12/03/2012

thanks

vijay    

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

HI,

I think 3/12/2012 2:09:54 PM is in M/DD/YYYY hh:mm:ss TT format.

If so, then use the following expression

= Date(Date#('3/12/2012 2:09:54 PM', 'M/D/YYYY hh:mm:ss TT'), 'DD/MM/YYYY')

HOpe this helps you.

Regards,

Jagan.

View solution in original post

5 Replies
eliran
Creator III
Creator III

Hi vijay,

You can use the Date() function:

Date(invoiceDate,'MM/DD/YYYY')

Hope it helps,

Eliran.

jagan
Luminary Alumni
Luminary Alumni

HI,

I think 3/12/2012 2:09:54 PM is in M/DD/YYYY hh:mm:ss TT format.

If so, then use the following expression

= Date(Date#('3/12/2012 2:09:54 PM', 'M/D/YYYY hh:mm:ss TT'), 'DD/MM/YYYY')

HOpe this helps you.

Regards,

Jagan.

jagjivvt
Creator
Creator
Author

thanks Jagan, it works

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this

     Date(Floor(Date#('3/12/2012 2:09:54 PM','M/DD/YYYY h:mm:ss TT')),'DD/MM/YYYY')

Celambarasan

jagjivvt
Creator
Creator
Author

Jagan

Thanks, it worked

Regards

Vijay