0

How do I change the date format to year.month.day?

3 replies

null
    • Paul_Chappell
    • 1 yr ago
    • Reported - view

    Something like this:

    let tempDate := today();
    let newDate:=year(tempDate) + "/" + format(month(tempDate), "00") + "/" + format(day(tempDate), "00")

    • Fred
    • 1 yr ago
    • Reported - view

    Here is the date/time formatting expression list

    If you need to change a date field to two digit year.mon.day then you could put something like this in a new formula field:

    format(fieldname, "YY.MM.DD")
      • Paul_Chappell
      • 1 yr ago
      • Reported - view

      Fred That's brilliant.  Never knew you could do that!

Content aside

  • 1 yr agoLast active
  • 3Replies
  • 83Views
  • 3 Following