0
edits
Changes
→Date/Time Variables
=Date/Time Variables=
==Standard Fields Date/Time==
:{| border="1" cellpadding="5"
|+
'''To display specific elements of the start dateStart Date, end date Start Time, End Date, End Time or close dateClose 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.
:{| border="1" cellpadding="5"|+|@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 ||AM or PM 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''|}:For End Date or Close Date replace ''fullstartdate'' with either ''fullenddate'' or ''fullclosedate'' accordingly:''(seconds are not available for standard date/time fields)''
'''Examples'''
@monthname(fullstartdate)@ @day(fullstartdate)@, @year(fullstartdate)@
* To display the Start End Time in the format ''"06:45PM"'' you would use: @hour(fullstartdatefullenddate)@:@minute(fullstartdatefullenddate)@@ampm(fullstartdatefullenddate)@
==Current Date/Time==
