How to format date from timestamp number into a format that spells out the month

Like you see the dates here. July 10, 2022. How do we show the date like that when it is in database as a timestamp number? I cant find it anywhere in the documentaion under FORMAT_DATETIME_LOCAL.

just search the forums, I have explained it somewhere already.

YYYY - full year, e.g. 2022,
YY last two digits of the year (22)
MMMM - full month (August)
MMM- short of month (AUG)
MM - number of month (08)
DD - day.
HH - hour
mm - minutes etc…

So Your would be

FORMAT_DATETIME_LOCAL(date, "MMMM DD, YYYY")
1 Like