Format Today’s Date with a Formula Field

While it is not possible to change the format of the Today’s Date merge field provided in the template builder, you can create a Formula field for Today’s Date in the format you want.

For example, to merge the date in a “Jan 29, 2025” format as opposed to MM/DD/YYYY format, you would create a custom text type formula field with the following formula:

CASE( MONTH( TODAY()) , 1, "Jan", 2, "Feb", 3, "Mar", 4, "Apr", 5, "May", 6, "Jun", 7, "Jul", 8, "Aug", 9, "Sep", 10, "Oct", 11, "Nov", "Dec")+" "+TEXT(DAY(TODAY()))+", "+TEXT(YEAR(TODAY()))