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. |
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:
Logic of
Templates
|
