Skip to main content
Question

Convert date to written out version of date

  • May 20, 2019
  • 0 replies
  • 88 views
Forum|alt.badge.img
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?
    This topic has been closed for replies.

    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)))

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • May 20, 2019
    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. 
    Terms & ConditionsAccessibility statement