Skip to main content

Month Formula - Name instead of Number

  • November 5, 2020
  • 2 replies
  • 129 views

Hello,
Just wondering if it’s possible for the Month formula to show the month instead of just the number?
Example attached. Any help would be very much appreciated :slightly_smiling_face:
Thank you,
Sarah

Listed Month (formula)|408x331

2 replies

Forum|alt.badge.img+3

I don’t know what is current formula that you use, but you can use DATETIME_FORMAT() on your date field and that use MMMM as format specifier which will return month as January, February, etc.

You can see all options for this function here:


  • Author
  • New Participant
  • November 5, 2020

I don’t know what is current formula that you use, but you can use DATETIME_FORMAT() on your date field and that use MMMM as format specifier which will return month as January, February, etc.

You can see all options for this function here:


Thank you so much! That worked :slightly_smiling_face: