Dates as variables in Exports, PDF and Email

Thursday, Oct 15, 2015

There are many different date & time variables that you can use on invoices, registration forms and emails. These include the dates & times specified for courses or internal events like updating a price and timestamps that are system recorded times linked to process steps or documents eg. modification and creation. In addition to these you can of course create your own custom date and time variables such as Date of birth eg. AVETMISS 7.0 Date of Birth, and any other date that can be specified on a document, process form or extranet form.

You can use the following dates in your emails and PDFs. If you don’t have a date that you want, or the date is variable you can choose to specify the date in a field on the process step, this could be set up as a free text field or alternatively a date field, though there is little leeway to modify the format of the date so experiment first to confirm how you want to display the date.

Course dates

Course Start Date. eg. Monday, 16 November 2015
[CourseDates:CourseDateStart]
Course End Date. eg. Monday, 16 November 2015
[CourseDates:CourseDateEnd]
Date the price will automatically change. eg. blank or Monday, 16 November 2015
[CourseDates:CourseDatePriceRuleDate]

Documents

AVETMISS 7.0 Date of Birth, the date as is selected by the student during registrations. eg. 1973-03-07
[Documents:DocumentContentDecoded12188]
Raw: AVETMISS 7.0 Date of Birth, the date as is selected by the student during registrations. eg. 1973-03-07
[Documents:DocumentContent12188]
Timestamp Submitted, the date & time that the document is submitted as a final document, non-draft, eg: Friday, 19 August 2016
[Documents:DocumentTimestampSubmitted]
Timestamp Created, the date & time that the document is created, draft or non-draft, eg: Friday, 19 August 2016
[Documents:DocumentTimestampCreated]

Status

Status Timestamp date only, that is when the PDF or Email is created by the system, usually at the time the process step is processed by the system. eg. Thursday, 15 October 2015
[Status:StatusTimestampDate]
Status Timestamp date and time, that is when the PDF or Email is created by the system, usually at the time the process step is processed by the system. eg. 3:25 AM Thursday, 15 October 2015
[Status:StatusTimestampDatetime]
Status Next Action Timestamp eg: 2016-08-19 05:06:00
[Status:StatusNextActionTimestamp]
Status Timestamp SQL format eg: 2016-08-19 05:06:00
[Status:StatusTimestamp]

Other formats/dates

If you need to have the date changed you may be able to export it to a different format, or ask us to look at a format modification that might work for your purposes.

Dates Format in export

You may use PHP date formats in Exports, see: http://php.net/manual/en/datetime.formats.date.php