Knowledgebase
Formatting a date format in report RTF templates.
Posted by on 20 January 2012 10:40 AM

It is possible to set a custom date format in saved documents by using \fdtm()\ function and a pattern variable in the following way: \fdtm(DateTime Variable, Pattern Variable)\

For example, if you have a DateTime variable \DEADLINE\ which is January 20, 2012, 10:30 AM, and you would like to display it as “Deadline is on Friday, January 20, 2012, at 10:30” in a generated document, please use the following code:

\fdtm(DEADLINE, '"Deadline is on" dddd. MMMM d. yyyy "at" hh:mm')\

It is important to define content of a pattern variable between ' ' quotes. If you would like to put some text like "Deadline is on", please use " " quotes.

(6 vote(s))
Helpful
Not helpful

Comments (2)
Vincent Garcia
07 September 2012 07:26 PM
how can I change 27.07.2012 to 27.07.12? I currently have this code in my template: \dtLinkJobs:CJOB_COMPLETED\
In Windows-Region the short date setting is dd.MM.yy
thank you for your reply!
Maksim Karganov (AIT)
10 September 2012 11:18 AM
Dear Vincent Garcia,

Thank you for your question.

To display data in the dd.MM.yy format, please use the following code in your invoice RTF template:
\fdtm(dtLinkJobs:CJOB_COMPLETED, 'dd.MM.yy')\

Feel free to contact us if you have any questions.

Best regards,
Maksim.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).