topic Re: Converting date from one format to another format in QlikView

Converting date from one format to another format

Anonymous — Fri, 22 Jan 2016 08:54:41 GMT

I have a Data set which has "Time" as 01/22/2016 21.21.47 PM"

So i need to show that Time to,

January 22,2016 only.

Please help me.

Thanks,

Chandra

sunny_talwar — Fri, 22 Jan 2016 11:13:59 GMT

You cannot have your time in 24 hr format and have AM/PM at the end. Assuming there is not AM/PM, try this:

Try this:

Date(Floor(TimeStamp#('01/22/2016 21.21.47', 'MM/DD/YYYY hh.mm.ss')), 'MMMM DD, YYYY') as Date

Anonymous — Fri, 22 Jan 2016 11:16:48 GMT

may be this only?

=date(YourTimeField,'MMMM DD, YYYY') as DateTime