8,849
edits
Changes
→Variables
:* This will return a numeric nodevalue in currency format. (See also [[Displaying_a_Number_Value_as_Currency#XML_data|Displaying a Number Value as Currency]].)
Date formatting node values:
The available syntax for date formats are as follows: ~formatdate(Date.nodevalue)~ >> returns the date in the user's date format ~year(Date.nodevalue)~ >> returns the year from the date ~month(Date.nodevalue)~ >> returns the month from the date ~monthname(Date.nodevalue)~ >> returns the month name from the date ~day(Date.nodevalue)~ >> returns the day from the date ~dayweek(Date.nodevalue)~ >> returns the day of week from the date
''Examples'':
Where there is a single entry of 2014-12-02 in an XML field
FORMAT: @xml.fieldname.Expenses-Static.row[# ~formatdate(col4.nodevalue)~ #]@ <br/>
YEAR: @xml.L1-XML Budget.Expenses-Static.row[# ~year(col4.nodevalue)~ #]@ <br/>
MONTH: @xml.L1-XML Budget.Expenses-Static.row[# ~month(col4.nodevalue)~ #]@ <br/>
MONTHNAME: @xml.L1-XML Budget.Expenses-Static.row[# ~monthname(col4.nodevalue)~ #]@ <br/>
DAY: @xml.L1-XML Budget.Expenses-Static.row[# ~day(col4.nodevalue)~ #]@ <br/>
DAYWEEK: @xml.L1-XML Budget.Expenses-Static.row[# ~dayweek(col4.nodevalue)~ #]@ <br/>
FORMAT: 2014-12-02
YEAR: 2014
MONTH: 12
MONTHNAME: December
DAY: 02
DAYWEEK: Tuesday
Counting nodes:
