0

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

3 replies

null
    • Paul_Chappell
    • 2 yrs ago
    • Reported - view

    Something like this:

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

    • Fred
    • 2 yrs 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
      • 2 yrs ago
      • Reported - view

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

Login to reply

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 116Views
  • 3 Following