Format is good for putting multiple values into a string, e.g. Format("Deal {1} - Phase {2}", thisRow.[Deal Number], thisRow.[Phase]), but otherwise it’s pretty dumb. Most it can do (unless I’m missing something) is format numbers to this many digits, as docs say here:
Yeah, technically you can recreate a date string with a formula like this
Format("{1:0000}-{2:00}-{3:00}", Today().Year(), Today().Month(), Today().Day())
But why if FormatDateTime, though experimental, does the job much faster and in alignment with format options found in the UI? Extracting Year(), Month() or MonthName(), and Day() to put them in a formatter just feels like smelly code to me (I’m coming from Java background; for me this is like using a very dumb version of String.format() instead of a native DateTimeFormatter class).