Formula Date Field
Hi I would like to create a date field to show as - Day Name, Date Month Name Year eg. Friday, 8 December 2020 I currently have a field Today with formula Today() - this shows as Friday, May-07...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis tested OK
var date MyDate = Today();
var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");
List(", ", $DayName,
List(" ",
ToText(Day($MyDate)),
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"),
ToText(Year($MyDate))))
------------------------------
Mark Shnier (YQC)
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var date MyDate = Today();
var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");
List(", ", $DayName,
List(" ",
ToText(Day($MyDate)),
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"),
ToText(Year($MyDate))))
------------------------------
Mark Shnier (YQC)
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Works Perfectly Mark. Thank you.
------------------------------
Jessica Matenga
------------------------------
------------------------------
Jessica Matenga
------------------------------