Discussions

Expand all | Collapse all

Convert date to written out version of date

  • 1.  Convert date to written out version of date

    Posted 05-20-2019 18:20
    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?


  • 2.  RE: Convert date to written out version of date

    Posted 05-20-2019 18:24
    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)))



  • 3.  RE: Convert date to written out version of date

    Posted 05-20-2019 18:59
    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!


  • 4.  RE: Convert date to written out version of date

    Posted 05-20-2019 19:05
    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">http://quickbase.uservoice.com/">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.