Inserting the Current Date or Time into Merged Documents
When creating or editing documents or document templates, AdvisorEngine CRM features a special merge field that allows you insert the current date and/or time in a format of your choosing into the final merged document (or email).
Note: This field is not available when using Merge Fields within
Outlook Online.
Adding the Date/Time Merge Field
- From within the document editor, select the Mailings tab.
- Click Insert Special Field > Date.
- Select a pre-formatted date/time option from the list (or enter your own into the text box using the letter codes listed below).
Warning!
The available date formats that can be selected are arranged DD/MM/YY, not the US standard of MM/DD/YY. Use the Letter Codes below to build your own date format as needed.
- Click OK to insert the date/time field into your document. It will display as {DATE} until merged.
Use the Preview Merge Results option to see if the merge field will produce the results you intend.
Editing or Removing the Date/Time Merge Field
To edit the format of the date/time field, right click on the {DATE} entry and choose Field Properties.
To remove the date/time field, right click on the {DATE} entry and choose Delete Field.
Letter Codes Reference
The following letter codes can be used to create custom date and time formats for use with the DATE merge field. Please note that capitalization matters! You can insert whatever punctuation you’d like between the letter codes for additional formatting.
The example column shows the output you would receive on Monday, February 3rd, 2018 at 4:05:06pm.
| Letter Code |
Output |
Example |
| d |
date |
3 |
| dd |
date (leading zero) |
03 |
| ddd |
day (abbreviated) |
Mon |
| dddd |
day |
Monday |
| M |
month (numerical) |
2 |
| MM |
month (numerical, leading zero) |
02 |
| MMM |
month (text, abbreviated) |
Feb |
| MMMM |
month (text) |
February |
| yy |
year (abbreviated) |
18 |
| yyyy |
year |
2018 |
| h |
hour (12-hour) |
4 |
| hh |
hour (12-hour, leading zero) |
04 |
| H |
hour (24-hour) |
16 |
| HH |
hour (24-hour, leading zero) |
16 |
| m |
minutes |
5 |
| mm |
minutes (leading zero) |
05 |
| s |
seconds |
6 |
| ss |
seconds (leading zero) |
06 |
| t |
A or P indicator |
P |
| tt |
AM or PM indicator |
PM |
Related Articles
New User Module 3-3: Documents and Correspondence
Documents Overview Learn about document storage in AE CRM. Documents Overview Adding Documents Learn how to get documents into a Record. Uploading Documents Creating New Documents Managing Documents and Folders Learn how to maintain your document ...
ClientView: Uploading Documents in Bulk
To upload multiple files into the ClientView Document Center, the app supports a “bulk upload” mechanism to quickly get a group of files into the system and sorted into the appropriate Client’s Document Center. Overview of Bulk Upload This feature ...
Changing the Inactivity Logoff Time
Firm administrators have the option to designate the amount of inactive time all users are allowed. AdvisorEngine CRM will automatically log off Users after the inactive time has been reached. Navigate to the Firm Preferences tab of Settings. Click ...
Dashboard Card: Year-to-Date (YTD) Revenue
Year-to-Date (YTD) Revenue is a visualization card available for AdvisorEngine CRM Dashboards. For a full list of available cards, see Dashboards Card Library. Year-to-Date (YTD) Revenue The Year-to-Date Revenue reports the total Client Revenue this ...
Dashboard Card: Total Actions Completed w/ Avg Completion Time
Total Actions Completed w/ Avg Completion Time is a visualization card available for AdvisorEngine CRM Dashboards. For a full list of available cards, see Dashboards Card Library. Total Actions Completed w/ Avg Completion Time The Total Actions ...