0
edits
Changes
→How to Display a Date or Time Format
=Date/Time=
==How to Display a Date or Time Format==
===Standard Fields Date/Time===
'''The following date variables are available for date format''':
:{| border="1" cellpadding="5"
|+
|+
|@startdate@||@enddate@||@closedate@||2009-01-23
|+
|@longstartdate@||@longenddate@||@longclosedate@||Friday, January 23, 2009
|+
|@fullstartdate@||@fullenddate@||@fullclosedate@||2009-01-23 15:40:00
|}
'''To display specific elements of the start date, end date or close date''':
*'''Note''': The ''Start Time'' and ''End Time'' are stored within the ''fullstartdate'' and ''fullenddate'' fields respectively, so are accessed using the variables listed below.
@month(fullstartdate)@ - month number in ''Start Date''
@monthname(fullstartdate)@ - name of month in ''Start Date''
@day(fullstartdate)@ - day in ''Start Date''
@dayweek(fullstartdate)@ - name of day in ''Start Date''
@year(fullstartdate)@ - year in ''Start Date''
@hour(fullstartdate)@ - returns the hour in ''Start Time'' using 12 hour clock (0-12)
@ampm(fullstartdate)@ to provide a reference for am/pm for ''Start Time''
@hour24(fullstartdate)@ - returns the hour in ''Start Time'' using 24 hour clock (0-24)
@minute(fullstartdate)@ - returns the minute in ''Start Time''
@second(fullstartdate)@ - returns the seconds in ''Start Time''
===Current Date/Time===
'''The following date variables are also available'''
:{| border="1" cellpadding="5"
|+
!Variable!!Content!!Display Format!!Comment
|+
||@currentdate@||full current date||2009 January 25||
|+
||@now@||full current date and time||2009 August 25 11:05AM||Workflows only. Not available within [[UTA]]s
|}
(seconds are not available for the current time)
@monthyear(datefield''fieldname'')@ - returns the month year value in datefield''fieldname''
@daymonth(datefield''fieldname'')@ - returns the day month value in datefield''fieldname''
@day(''fieldname'For Time fields:')@ - returns the day value in ''fieldname''
@hour(datefield''fieldname'')@ - returns the hour value in datefield ''fieldname'' using 12 hour clock (0-12)
@ampm(datefield''fieldname'')@ to provide a reference for am/pmfor ''fieldname''
@hour24(datefield''fieldname'')@ - returns the hour value in datefield ''fieldname'' using 24 hour clock (0-24)
@minute(datefield''fieldname'')@ - returns the minute value in datefield''fieldname''
@second(datefield''fieldname'')@ - returns the second value in datefield''fieldname''
==How to hide a variable if it is missing==