Convert String to Timestamp

[Anonymous]

I have a string datetime property of this format: 20181030T133100.000 GMT

and I would like to format it into 30/10/2018 13:31 (DD/MM/YYYY hh:mm).

I've checked this forum: How to convert timestamp to date format

and was able to get my result by:

Date(Date#(SUBFIELD(PROPERTYDATETIME,'T',1),'YYYYMMDD'),'DD/MM/YYYY') &' '& Date(Date#(SUBFIELD(SUBFIELD(PROPERTYDATETIME,'T',2),'.',1),'hhmmss'),'hh:mm')

However, is there a better method of using the TimeStamp function of splitting the property up to format the datetime instead?

Thanks!

[Anil_Babu_Samineni]

Try this?

=Date(Date#(Replace(Field,'T',' '),'YYYYMMDD hhmmss.fff'),'DD/MM/YYYY hh:mm')

Or

=Date(Date#(Replace(SubField(Field, ' ',1),'T',' '),'YYYYMMDD hhmmss.fff'),'DD/MM/YYYY hh:mm')

[Anonymous · Accepted solution]

use stringfunction to get rid of text "GMT"

then use

=timestamp(date('20181030T133100.000'),'DD/MM/YYYY hh:mm') 

which gives me (you may Format to your dateformat)

[Anonymous]

Thanks!

Ended up with this:

timestamp(date(SUBFIELD(PROPERTYDATETIME,' ',1)),'DD/MM/YYYY hh:mm')

was wondering if I was able to use the formatting to get rid of the gmt... but this works and much neater than mine hahas ^^