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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendvar 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
------------------------------
Thank you Mark!
------------------------------
Harris Tse
------------------------------
