Converting timestamp to date issue

[#1]

Please guys I have a problem.

I have this timestamp format '2016-11-01 00:01:00.0000000 +00:00' and I want to convert it to date format.

Thank you

[tamilarasu]

Hi Lou,

Date(Date#(SubField(FieldName, ' '),'YYYY-MM-DD'),'YYYY-MM-DD')

[hemanthaanichet]

Hi Lou,

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

Regards

Hemanth

[jonathandienst · Accepted solution]

=Date#(SubField(FieldName, ' ', 1),'YYYY-MM-DD')             // date in ymd format

or

=Date(Date#(SubField(FieldName, ' ', 1),'YYYY-MM-DD'))    // date in the default format for your system

[#5]

Thank you Jonathan, it works