Formatting Datetimes

[haymarketpaul]

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]

Hi,

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

[haymarketpaul]

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')

[#4]

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 · Accepted solution]

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]

Thanks bit tidier than my effort

[#7]

PFA