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 docid\ xtaqdzvlbtakjxrnpfwe9 sample usage monthend('2020 05 12') returns 2020 05 31 supported data types input type return type logic docid\ xtaqdzvlbtakjxrnpfwe9 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 docid\ n9trvqonnbknql9drnbp6 unsupported data types return null