topic Date Time issue in QlikView

Date Time issue

Anonymous — Fri, 21 Nov 2014 03:59:59 GMT

Hi All,

I am having a date field such as " 201-04-25T01:53:1Z" From this I need extract only Date field. I have used Purgechar(Datefield,'T,Z').

But it dint worked. Any one having idea on this

-Jay

JonnyPoole — Fri, 21 Nov 2014 04:05:26 GMT

Is there a missing 4th digit like....2014-04-25T01:53:1Z" ??

You could trythis:

date(date#( left(Datefield,10) ,'YYYY-MM-DD'))

SunilChauhan — Fri, 21 Nov 2014 04:12:05 GMT

date(date#( Datefield ,'DD-MM-YYYY'))

PrashantSangle — Fri, 21 Nov 2014 04:42:07 GMT

Hi,

Try like

date(date#(Purgechar(Datefield,'T,Z'),'YYYY-MM-DDhh:mm:s'),'YYYY-MM-DD hh:mm:ss')

Regards,

jonathandienst — Fri, 21 Nov 2014 05:11:36 GMT

That's correct, except that PurgeChar() only takes 2 parameters, so it should read:

date(date#(Purgechar(Datefield,'TZtz'),'YYYY-MM-DDhh:mm:s'),'YYYY-MM-DD hh:mm:ss')

HTH

Jonathan

PrashantSangle — Fri, 21 Nov 2014 05:21:17 GMT

Hi,

my bad syntax error . You are write HTH.

Thanks for correction

Regards