topic Re: How to date format a complicated timestamp ? in App Development

How to date format a complicated timestamp ?

Domino1 — Fri, 29 Apr 2022 12:35:16 GMT

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 — Fri, 29 Apr 2022 13:13:29 GMT

Hi Domino 1,

Please try this.

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