Converting Date to Text

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community