skip to Main Content

xplan xmerge

Search
Generic filters
Exact matches only
Filter by Custom Post Type

Try these: client detailstasks syntaxsuperannuation

Converting a document variable to a Formatted Date

Portfolio Reports or IPS reports are commonly built in ways that allow the user to customise various aspects of the report, each time they run it.  The most common one for these reports is usually the date.  This is performed by adding a merge variable into the coded template and when its run (each time) the user is prompted to enter a date they want the report to be based on.

Usually these inputs are in the form of YYYYMMDD or the reverse.

The code below will convert the variable (“Report_Date_YYYYMMDD”) into a formatted and client friendly date.

Setec Astronomy

<:=dateutils.getDateTime(str($var(‘%Report_Date_YYYYMMDD%’))).strftime(‘%d %B, %Y‘):>

See also

Back To Top