TB Community-
Here is an equation that may be helpful for your applications. This will format a date field from MM DD YYYY or DD MM YYYY to similar to 1st of January 202X.
This is an equation field formula and change the “Date of Initial Declaration” to your respective field.
Equation:
CONCAT(DAYOFMONTH({Date of Initial Declaration}),IF(DAYOFMONTH({Date of Initial Declaration})=1 || 21 ||31,'st', IF(DAYOFMONTH({Date of Initial Declaration})=2 || 22,'nd', IF(DAYOFMONTH({Date of Initial Declaration})=3 || 23,'nd', 'th'))),CHAR(32),'of ',DATE_FORMAT({Date of Initial Declaration}, '%M %Y'))
Results Example: 1st of January 2024
Cheers,
Adam