The NumberPhrase Function

April 14, 2011 User Reference
Thumbnail image for The NumberPhrase Function

This function converts a number to words, in a number of languages. Suppose a data element with name ‘area’ has a value 1234: <<NumberPhrase(area,”af”,”ToUpper”)>> yields “EEN DUISEND TWEE HONDERD VIER EN DERTIG” <<NumberPhrase(area,”en”,”ToUpper”)>> yields “ONE THOUSAND TWO HUNDRED THIRTY-FOUR” Notes: i) The language code ‘af’ is the ISO639-2 code for Afrikaans (see ISO639-2 standards). ii) […]

Read the full article →

Format a date in archaic form

October 2, 2009 Cookbook
Thumbnail image for Format a date in archaic form

Using standard XpressDox functions and commands, XpressDox renders a date in archaic form, i.e. 2009-09-02 becomes “the 2nd day of October in the Year of Our Lord Two Thousand and Nine”.

Read the full article →