Date and Time Functions
In most cases the database stores the complete date and time. Certain commands can be used to customize the format of the 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:
-
fmdt
-
wd
-
date
-
time
NOTE: These functions return the value according to the 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 a 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 the following format: 9/20/2006. |
|
\PROJECT_DATE_DEADLINE\ |
Project template variable |
Project deadline in the following format: 9/20/2006. |
|
\PROJECT_DATE_COMPLETED\ |
Project template variable |
Date of the project completion in the following format: 9/20/2006. |
|
\ASSIGNED\ |
Client Jobs template variable |
Date when the job was assigned in the following format: 9/20/2006. |
|
\DEADLINE\ |
Client Jobs template variable |
Job deadline in the following format: 9/20/2006 |
|
\COMPLETED\
|
Client Jobs template variable |
Completion date in the following format: 9/20/2006. |
|
\DONE\ |
Client Jobs template variable |
Completion date in the following format: 9/20/2006. |
|
\START\ \ESTSTART\ |
Quotes template variable |
Date assigned in the following format: 9/20/2006. |
|
\COMPLETION\ \ESTCOMPLETION\ |
Quotes template variable |
Deadline date in the following format: 9/20/2006. |
Syntax
Date and time functions are added to the variable in the following way:
\function(VARIABLE)\
Example
To add the wd function to the \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: