Convert date to written out version of date

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
The date field has an option to spell out the month. However, it abbreviates the month to the first three letters and is in all caps. I need an options that spells out the ENTIRE month, and formats it the way I want. I am guessing my only option is a formula date field, but before I did the work I wanted to reach out and see if anyone had any other options. Maybe I missed something?
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
  • annoyed

Posted 2 months ago

  • 0
  • 1
you can make a text field like this and adjust the names of the months.

var date MyDate = [... insert your date field here ...];



List("-",
Case(Month($MyDate),
1,"Jan",
2,"Feb",
3,"Mar",
4,"Apr",
5,"May",
6,"Jun",
7,"Jul",
8,"Aug",
9,"Sep",
10,"Oct",
11,"Nov",
12,"Dec"),
Right("0" & ToText(Day($MyDate)),2),
ToText(Year($MyDate)))

Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
thanks so much. I am a bit frustrated because I am going to have to do this across the entire app, over 50 different date fields. Definitely not the best solution but better than not having it at all. thanks again!
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,338 Points 10k badge 2x thumb
Hi Ursula,

Currently using a formula field to get the full month would be the best way to get your dates to display that way. If an alternative built into the date type fields would be helpful I would suggest giving that as feedback on our User Voice page. User Voice is a feedback tool our Product Management team uses to collect user feedback on enhancement and feature requests from users. The Quick Base User Voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. 

If you do decide to add that to our User Voice I would suggest posting a link to your suggestion back here so that other Community members with the same need can add their vote as well.