Forum Discussion

WendyShoef's avatar
WendyShoef
Qrew Cadet
7 years ago

Display today's date in ""F d, Y"" (PHP date format)

I'm sure there is a simple way to do this, but I am struggling. I know you have the Date() function but that only accepts text. I've tried Date( Year( Today() ), Month( Today() ), Day( Today() )...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Is this what you want?

var date MyDate = (insert your date field here);

List("-",
Case(Month($MyDate),
1,"Jan",
2,"Feb",
3,"Mar",
4,"Apr",
5,"May",
6,"Jun",
7,"Jul",
8,"Aug",
9,"Sep",
10,"Oct",
11,"Nov",
12,"Dec"),
Right("0" & ToText(Day($MyDate)),2),
ToText(Year($MyDate)))