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

markshnier__you · Answer

var date MyDate = [My Date Field];
&nbsp;
var text DD = ToText(Day($MyDate));
&nbsp;
var text MonthName =&nbsp;
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");
&nbsp;
var text YYYY = ToText(Year($Mydate));
&nbsp;
List(" ", $DD, $MonthName, $YYYY)------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

harristse · Answer

Thank you Mark!&nbsp;------------------------------Harris Tse------------------------------

Forum Discussion

Converting Date to Text