converting timestamp to date

[Lalitha]

Hi,

I have a timestamp  like this: 2021-03-23 19:16:08.1010000 +00:00 

Please help how to convert the above timestamp to the Date filed - 'MM/DD/YYYY' format. 

Thanks in advance..! 

[NitinK7]

may be

Date(Date#(Subfield(Date filed,' ',1),'YYYY-MM-DD'),'MM/DD/YYYY')

[Lalitha]

Hi Nitin,

Thanks for you reply, I tried this but it’s not working.

[NitinK7]

could you please attach here your sample data for this field?

[NitinK7]

could you please attach here your sample data for this field?