Forum Discussion

UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
6 years ago

Convert date to written out version of date

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?
Formulas and functions
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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)))

    • UrsulaLl's avatar
      UrsulaLl
      Qrew Assistant Captain
      6 years ago
      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!
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    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.