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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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() ) ) but that doesn't work because the Year, Month, Day parts are date numbers. 

I've tried using various formulas including ToFormattedText, ToText.

Also, tried using AdjustYear([Date], 0)  but the output is actually mm-dd-yyyy not as indicated in formula reference ( "AdjustYear(ToDate("2/20/99"), 2) returns February 20, 2001" ) on https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=35&rl=4m.

NOTE: PHP Date format "F d, Y" would yield March 5, 2019
Photo of Wendy Shoef

Wendy Shoef

  • 660 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
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)))
Photo of Wendy Shoef

Wendy Shoef

  • 660 Points 500 badge 2x thumb
Kind of works, but it Needs to be "March 5, 2019" not "March-05-2019" so the list part with "-" doesn't work.

Thanks for the reply... seems overly complicated for as many times as I need to use it. But will probably just load a date .js function so I can use it repeatedly.