How to date format a complicated timestamp ?

[Domino1]

 Hello,

Here is my timestamp :   

2021-10-05 00:00:00.0000000 +00:00

Need to show as  ' MM DDD YYYY' 

Just using Date and floor functions are ineffective.

[vish123 · Accepted solution]

Hi Domino 1,

Please try this.

Date(Date#(left(date,10),'YYYY-MM-DD'),'MM DD YYYY')