Forum Discussion

HarrisTse's avatar
HarrisTse
Qrew Member
3 months ago

Converting Date to Text

Hi guys, I have a question for converting date to text in QuickBase. For example, I have a date field show 16-02-24. But I want it to show as 16th February 2024. Can someone help me please? Thank you!!



------------------------------
Harris Tse
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 months ago
    var date MyDate = [My Date Field];
     
    var text DD = ToText(Day($MyDate));
     
    var text MonthName = 
    Case(Month($MyDate),
    1,"January",
    2,"February",
    3,"March",
    4,"April",
    5,"May",
    6,"June",
    7,"July",
    8,"August",
    9,"September",
    10,"October",
    11,"November",
    12,"December");
     
    var text YYYY = ToText(Year($Mydate));
     
    List(" ", $DD, $MonthName, $YYYY)


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • HarrisTse's avatar
      HarrisTse
      Qrew Member
      3 months ago

      Thank you Mark! 



      ------------------------------
      Harris Tse
      ------------------------------