topic Re: Date conversation in QlikView

Date conversation

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can any one please help me

In date field i have January 8, 2016 21:10.I have to split this Time stamp to date and time in 2 separate columns like

Date(Floor(Timestamp#(Date,'MMMM/DD/YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

Time(Frac(Timestamp#(Date,'MMMM/DD/YYYY hh:mm')),'hh:mm') as Time,

Now my doubt is how to represent "January 8, 2016 21:10" this format of date in above functions.

January 8, 2016 21:10

January 12, 2015 20:10

Anonymous — Mon, 28 Mar 2016 15:38:19 GMT

'MMMM D, YYYY hh:mm'

sunny_talwar — Mon, 28 Mar 2016 15:39:25 GMT

May be this:

Date(Floor(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

Time(Frac(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'hh:mm') as Time,

Chanty4u — Mon, 28 Mar 2016 15:40:18 GMT

Date(Floor(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'MM/DD/YYYY') as [Date1],

Time(Frac(Timestamp#(Date,'MMMM D, YYYY hh:mm')),'hh:mm') as Time,