|
In most cases database stores complete date and time. Certain commands can be used to customize the format of output date and time data (you may want to output only the day of the week or only the time etc.).
The following date and time functions can be used in all templates:
 Note: These functions return value according to Regional and Language Options settings in your system. These options can be changed wit the help of your Windows Control Panel.
The same variable will be displayed in different way depending on the function used.
FUNCTION:
|
VARIABLE VALUE:
|
FUNCTION APPLIED:
|
fmdt
|
9/20/06 6:00 PM
|
Wednesday, September 20, 2006 6:00 PM
|
9/20/06
|
Wednesday, September 20, 2006
|
wd
|
9/20/06 6:00 PM
|
Wednesday
|
9/20/06
|
Wednesday
|
date
|
9/20/06 6:00 PM
|
09/20/06
|
9/20/06
|
09/20/06
|
time
|
9/20/06 6:00 PM
|
6:00 PM
|
9/20/06
|
(empty row)
|
Date and time functions are accessible in all templates and can be applied to:
| • | All variables from datasets which return date and time. |
| • | All variables from the following table: |
VARIABLE:
|
TYPE:
|
DESCRIPTION:
|
\PROJECT_DATE_STARTED\
|
Project template variable
|
Date when the project was started in following format: 9/20/2006.
|
\PROJECT_DATE_DEADLINE\
|
Project template variable
|
Project deadline in following format: 9/20/2006.
|
\PROJECT_DATE_COMPLETED\
|
Project template variable
|
Date of the project completion in following format: 9/20/2006.
|
\ASSIGNED\
|
Client Jobs template variable
|
Date when the job was assigned in following format: 9/20/2006.
|
\DEADLINE\
|
Client Jobs template variable
|
Job deadline in following format: 9/20/2006
|
\COMPLETED\
|
Client Jobs template variable
|
Completion date in following format: 9/20/2006.
|
\DONE\
|
Client Jobs template variable
|
Completion date in following format: 9/20/2006.
|
\START\
\ESTSTART\
|
Quotes template variable
|
Date assigned in following format: 9/20/2006.
|
\COMPLETION\
\ESTCOMPLETION\
|
Quotes template variable
|
Deadline date in following format: 9/20/2006.
|
Date and time functions are added to the variable in the following way:
\function(VARIABLE)\
 Example
To add wd function to \ASSIGNED\ variable from the client jobs template, change the variable syntax in the following way:
\wd(ASSIGNED)\
The result will be the day of the week, when the job was assigned (e.g. Wednesday).
See also:
Logic of Templates
| 
Date and Time Functions