Formula Date Field

Question

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

------------------------------
Jessica Matenga
------------------------------

MarkShnierYou · Answer

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

Sign up

Login to the community