Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jagjivvt
Contributor

Date conversion

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

thanks

vijay    

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Date conversion

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.

5 Replies
eliran_s
Contributor II

Date conversion

Hi vijay,

You can use the Date() function:

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

Hope it helps,

Eliran.

MVP
MVP

Date conversion

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
Contributor

Date conversion

thanks Jagan, it works

Date conversion

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
Contributor

Re: Date conversion

Jagan

Thanks, it worked

Regards

Vijay   

Community Browser