0
edits
Changes
→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