Date and Time Functions

To customize the precision of the date presentation in your templates (you may want to output only the day of the week or only the time etc.) you can use special functions.

Note: These functions return value according to Regional and Language Options settings in your system.

Let us tell you about the work of the date and time functions on example, when English (United States) is set as regional standard at Regional and Language Options.

FUNCTION:	VARIABLE VALUE:	FUNCTION APPLIED:
fmdt	9/20/06 6:00 PM	Wednesday, September 20, 2006 6:00 PM
fmdt	9/20/06	Wednesday, September 20, 2006
wd	9/20/06 6:00 PM	Wednesday
wd	9/20/06	Wednesday
date	9/20/06 6:00 PM	09/20/06
date	9/20/06	09/20/06
time	9/20/06 6:00 PM	6:00 PM
time	9/20/06	(empty row)

VARIABLE:	TYPE:	DESCRIPTION:
\PROJECT_DATE_STARTED\	Project template variable	Date when the Project was started in following format: 10/4/2006.
\PROJECT_DATE_DEADLINE\	Project template variable	Project deadline in following format: 10/4/2006.
\PROJECT_DATE_COMPLETED\	Project template variable	Date of the Project completion in following format: 10/4/2006.
\ASSIGNED\	Client Jobs template variable	Date when the Job was assigned in following format: 10/4/2006.
\DEADLINE\	Client Jobs template variable	Job deadline in following format: 10/4/2006
\COMPLETED\ \DONE\	Client Jobs template variable	Completion date in following format: 10/4/2006.
\START\ \ESTSTART\	Quotes template variable	Date assigned in following format: 10/4/2006.
\COMPLETION\ \ESTCOMPLETION\	Quotes template variable	Deadline date in following format: 10/4/2006.

Example of using date and time function on \ASSIGNED\ variable from the Client Jobs template:

The result will be the day of the week, when the Job was assigned (e.g. Wednesday).