Changes

Web Page View Field Variables

478 bytes added, 19:39, 25 February 2009
How to display a list of UTA Level 1 Activities, Contacts or Companies
~date_format(startdate,'%h:%i %p') as starttime~
</pre>
 
*Note: If you wish to use ''"orderby=startdate"'', along with a date format other than yyyy-mm-dd you must use a slightly different syntax.
*Using ''"~date_format(startdate,'%d-%m-%Y') as startdate~"'' when using ''"orderby=startdate"'' will cause the date to be ordered by dd-mm-yyyy (rather than yyyy-mm-dd, which is chronological)
 
*To avoid this, change ''"date_format(startdate,'%d-%m-%Y') as '''startdate'''"'' to ''"date_format(startdate,'%d-%m-%Y') as '''sdate'''"''
 
 
'''To list level two entity at level one using level two fieldname instead of customfield ID
0
edits