topic Re: Date format Issue in QlikView

Date format Issue

amit_saini — Mon, 25 Jun 2018 12:00:32 GMT

Hi Folks,

I'm trying to change Date format , but not sure why only some records are changing and not all.

Date(Date#(Date, 'MMM DD YYYY HH:MM[.fff]TT'),'MM/DD/YYYY') as MyNewDate,

I want to convert Date to this Format : 2/24/2015 9:30:15 AM

PFA!

Regards,

sunny_talwar — Mon, 25 Jun 2018 12:19:11 GMT

Try this

Date(Floor(Date#(Replace(Date, ' ', ' '), 'MMM D YYYY hh:mm[.fff]TT')),'MM/DD/YYYY') as MyNewDate;

YoussefBelloum — Mon, 25 Jun 2018 13:13:32 GMT

in this exampe using an inline, does Replace(Date,' ','') act like Trim(Date) ? because I was trying with Trim(Date) and it didn't work..

sunny_talwar — Mon, 25 Jun 2018 13:22:06 GMT

Trim removes extra spaces from the beginning and ending of the string... here I am replacing two spaces with a single space in between the string

YoussefBelloum — Mon, 25 Jun 2018 13:30:08 GMT

I really thought TRIM() removes all spaces including those in the middle... Thank you

sunny_talwar — Mon, 25 Jun 2018 13:32:28 GMT

Nope, that is what you use Replace() for..

YoussefBelloum — Mon, 25 Jun 2018 13:38:36 GMT

Yes, I see