Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
4 years ago

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

------------------------------
Jessica Matenga
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------
    • JessicaMatenga's avatar
      JessicaMatenga
      Qrew Trainee
      4 years ago
      Works Perfectly Mark. Thank you.

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