date()

converts a value to a date docid\ xtaqdzvlbtakjxrnpfwe9 , including handling relative dates syntax date(value\[, startingdate]) value the value to convert to a date this value may be an exact date ("2025 01 01"), or in relative dates docid\ lvlfv 1a epbysjqj5fjc form ("+1w+3d") if passed a number docid\ uci5tctfvbhonej6zqijg , then the number will be assumed to be a unix timestamp (seconds since the epoch) startingdate (optional) if passed, will use this date as the starting point date for the relative date return type date docid\ xtaqdzvlbtakjxrnpfwe9 , or null docid\ n9trvqonnbknql9drnbp6 if unable to parse or convert the value into a date examples date() returns the current date date(" 3m") returns the date three months ago date(1744206569) returns the date of april 9, 2025 (by converting from a unix timestamp) date("2025 12 25") returns the exact date of dec 25, 2025 date("+6w", createdate) returns a date six weeks from the value of createdate