topic Formatting Datetimes in QlikView

Formatting Datetimes

haymarketpaul — Fri, 10 Apr 2015 10:05:35 GMT

I am wanting to format Datetimes that look like this

2005-10-28T15:28:24Z

into this

28-10-2005 15:28:24

i thought this might work but doesn't seem to return anything?

Timestamp(Timestamp#(Trim(member.BouncedSince),'YYYY-MM-DDThh:mm:ssZ'),'DD-MM-YYYY hh:mm:ss') as BounceDateTime

Am i doing something wrong or is there a better way?

fvelascog72 — Fri, 10 Apr 2015 10:12:56 GMT

Hi,

Before applying timestamp format you could use purge to eliminate Z and T.

haymarketpaul — Fri, 10 Apr 2015 10:17:35 GMT

Thanks for reply i've used this for now which is very similar to your suggestion.

Timestamp(Timestamp#(Trim(replace(replace(member.BouncedSince,'T',' '),'Z','')),'YYYY-MM-DD hh:mm:ss'),'DD-MM-YYYY hh:mm:ss')

Fri, 10 Apr 2015 10:41:36 GMT

Hi Paul,

Could you please try this:

=timestamp#(Replace(Replace('2005-10-28T15:28:24Z','T',' '),'Z',''),'YYYY-MM-DD HH:MM:SS')

Thanks!

fvelascog72 — Fri, 10 Apr 2015 10:48:37 GMT

With PurgeChar will be something like this:

Timestamp(Timestamp#(PurgeChar(member.BouncedSince,'TZ'),'YYYY-MM-DD hh:mm:ss'),'DD-MM-YYYY hh:mm:ss')

haymarketpaul — Fri, 10 Apr 2015 10:53:54 GMT

Thanks bit tidier than my effort

Fri, 10 Apr 2015 11:00:57 GMT

PFA