Formatting of Date Field

[THECUSE4463]

I am trying to convert a date field so that it appears as follows: May 31, 2023.

The first formula in the screenshot I've attached first results in the date appearing as 2023-05-31 (Date format).

The second formula converts the result into the following 05/31/2023 (String format).

How would I go about configuring my workflow so that the first result (2023-05-31) appears as May 31, 2023?

[ShankerV]

Hi, Try the below one.

DateTimeFormat([Field1],"%B %d, %Y")

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @THECUSE4463, you can do that with the following expression:

DateTimeFormat([Date],'%B %d, %Y')

[THECUSE4463]

Thank you very much. That worked.