Carrot reference
Functions

formatDate()

converts a given value of type date into a string syntax formatdate(date,'format','locale') date the date to be formatted, eg startdateorg format the format of the date, eg 'mm dd yyy' supports any formatting inputs from date fns locale (optional) the language of the date, eg 'es' default 'en us' american english supports any ietf bcp 47 language tag sample usage formatdate(startdateorg) returns the value of startdateorg as a string formatdate(startdateorg, 'eeee, dd mmmm yyyy) returns the value of the startdateorg formatted as a string for example "wednesday, 15 june 2022 " formatdate(startdateorg, 'mm dd yyyy','es') returns the value of startdateorg as a string in spanish for example "miercoles, 14 junio 2022" supported data types input type return type logic date docid\ xtaqdzvlbtakjxrnpfwe9 string docid\ ujw2aqaktel5uuklup73s if a date value is passed, it's value will returned as a string unsupported data types null docid\ n9trvqonnbknql9drnbp6 unsupported data types return null