FORMAT_DATE and TEXT function codes

Hey @arnold_wikey,

Are you trying to find information for formatting in the API, or for use in the formula column?

If you’re looking for more information on the formula, you can use our list of available formulas for reference.

If you’re trying to do this in the API - could you give us a bit more information on what you’re looking for?

Best,
Daniel

Hi @dsilva,

I am looking to find information on formatting through the formula column. I have visited the page with the available formulas, but there is not enough information there for me.

For example, for the TEXT function there is a formatting string “$#,##0.00”. I can understand what the format string is doing, but:

• Are there other tokens I can use?
• Is “$#,###.##” also a valid format string? How can I determine this without having to try all possible combinations by hand?

Also for example, the FORMAT_DATE function has a formatting string “dddd, MMMM Do YYYY” shown. Same as the TEXT function above: are there other tokens I can use? What sorts of combinations are valid and available to me?

Having more experience with Excel, I use that as a basis and just give it a try. It would be great if it was more thoroughly documented.

Hi @dsilva,

Is this something that resides deep within Monday.com source code? I am still not able to find a complete reference to these formatting tokens as they pertain specifically to Monday.com.

Here’s what I found through testing for FORMAT_DATE. Maybe someone can do the TEXT function and monday can add it to some documentation.

Hey @arnold_wikey and @JCorrell

I wanted to chime in as a formula-lover myself! I do agree this could be documented better and i appreciate your effort into sharing the knowledge you’ve gathered via testing 🙂

@JCorrell to add on to your list, here are the things I’ve found myself for FORMAT_DATE:

Q - Will show the Quarter of the date (Jan, Feb and March would show 1, for example);
Do - Day ordered (16th over just 16) - generally, adding “o” would make the value ordered.
W - shows the Week number of the date value;
L - This would format the date as Month/Day/Year

For TEXT, generally most things fly in my experience, and I haven’t found anything particularly useful… except “:” as a token. This takes a numeric value within your board and formats it as a time value, where 3600 would equal 1 hour (as in 3600 seconds):

I hope this helps a bit 🙂 I’ll share your feedback with the team, as I do think this could be a much smoother process than trial and error.

-Alex

Good to know. Here is the updated FORMAT_DATE codes:

*** Updated to add: E = Day of the week as 1-7 (Sun = 7)

@JCorrell

Thanks for taking the time to do that for us! I’ll try and free up a bit of time to make this an easily shareable resource on our end, just needs a bit of setup time to get right 🙂

Appreciate your effort here, as always. Sharing is caring! ⭐

-Alex

Awesome! Looking forward to seeing that.