If you’re using formatDate
, make sure the variable type of the field or cell accepts a string, not a date.
Also make sure that 1.date
contains a Date type, not a date-like String. If it’s a date-like String type you’ll need to convert that into a Date type before you can use formatDate
. For more information, see Wrong formatDate - #4 by samliew