Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date format Conversion

Hi there,

I have a date  with this format: Apr  13 2012  1:07PM and i want to convert it into 13/4/2012.

Any help?!

Thank you.

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Date format Conversion

Try replacing the double spaces with single spaces:

date(floor(timestamp#(replace(DATEFIELD,'  ',' '),'MMM DD YYYY h:mmTT')),'DD/M/YYYY') as NEWDATEFIELD


talk is cheap, supply exceeds demand
6 Replies
jsn
Honored Contributor

Re: Date format Conversion

date(floor(timestamp#(DATEFIELD,'MMM  DD YYYY  h:mmTT')),'DD/M/YYYY') as NEWDATEFIELD

Not applicable

Re: Date format Conversion

Thank you for your answer!

The problem remailns unfortunately in most of the records even though some have been transformed the way i wanted to.

For example: Feb  6 2012  9:26AM has been successfuly changed

But  Feb  6 2012 11:38AM has not.

er_mohit
Honored Contributor II

Re: Date format Conversion

you change format hh:mmTT as expression in johannes sunden

hope this will helps you

MVP & Luminary
MVP & Luminary

Re: Date format Conversion

Try replacing the double spaces with single spaces:

date(floor(timestamp#(replace(DATEFIELD,'  ',' '),'MMM DD YYYY h:mmTT')),'DD/M/YYYY') as NEWDATEFIELD


talk is cheap, supply exceeds demand
Not applicable

Re: Date format Conversion

Thank you all! I fixed it!

jsn
Honored Contributor

Re: Date format Conversion

Haha, and I paid such attention to get the double spaces in there to match the date format you posted in the original post..

Glad you got it up and running mate!