monthEnd()

returns the last day of a given month syntax monthend(\[date]) date (optional) the date from which to derive the last day of that date's month return type date docid\ xtaqdzvlbtakjxrnpfwe9 sample usage monthend('2020 05 12') returns 2020 05 31 supported data types input type return type logic date docid\ xtaqdzvlbtakjxrnpfwe9 date docid\ xtaqdzvlbtakjxrnpfwe9 the input date specifies the desired month the month is then used to determine the final date in that month unsupported data types null docid\ n9trvqonnbknql9drnbp6 unsupported data types return null