Date: Thu, 28 Mar 2024 15:43:24 +0000 (UTC) Message-ID: <1151296180.8755.1711640604851@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8754_934267050.1711640604847" ------=_Part_8754_934267050.1711640604847 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Format takes a template string and 0 or more additional arguments which = are then substituted into the template string. Because all values in termin= al clauses within TQL are strings, this can be very useful when trying to g= enerate values based on the output of other functions (such as dates & = times).
The first template argument should be a string, with zero-based values s= urounded by curly braces representing each of the arguments to be subsitute= d:
Format= (template, arg1, arg2... argN)
The below example will take the current day/month and form a new date st= ring value based on their values and the year 2011 (Note: This is a rather = naive example and will not work if the current date happens to be a leap da= y in a leap year).
Entity= Type =3D Incident AND CreatedAt >=3D Format('2010-{0}-{1}', DayOfDate(To= day()), MonthOfDate(Today()))