How to create a dynamic date that updates based on a reference date?
Overview
Steps to Create Dynamic Date Field
- Place the cursor where you want the date to be displayed.
- Click More > Fields.
- Under Autofields, choose the Date field.
- Choose Create Custom Date Field
Name the Dynamic Date Field:
- Named Custom Date Fields will be saved under Date for later use. Changes made to any one of the date fields in the document will automatically change all the fields with the same name.
- Enter any name for the date field for using it elsewhere in the document
Add/Subtract Days:
- Add or subtract days/months/years and this will reflect on the custom date.
Exclude Weekdays/ Weekends:
- Exclude weekdays or weekends as required.
You also might need an adjustment if the resulting date falls on a weekend (Sat/Sun), it should be moved to the next working day (Monday).
Additional Notes:
- The format "hh:mm a" will format the time as "10:30 AM"
- The format "MMMM dd, yyyy a" will display the date as "March 26, 2025 AM"
- The format D MMM YY HH:mm:ss will render - (1 Jun 21, 13:42:16 pm)
- The format EEE DD MM YYYY hh:mm z will render - (Sat, 10-07-2021, 01:06 IST)
Shortcut | Renders |
D | Date in single digit (1-9) |
DD | Date in two digits (01-31) |
MM | Months in two digits (01-12) |
MMM | Months in short text format (Jan-Dec) |
MMMM | Months as full names (January-December) |
YY | Year in two digits (00-99) |
YYYY | Year in four digits (2021) |
EEE | Day in short text format (Sun-Sat) |
EEEE | Days as full names (Sunday-Saturday) |
hh:mm:ss | Time with hour, minutes, seconds and meridiem. (04:57:26 PM) |
h:mm:ss | Time with hour in a single digit, minutes, seconds and meridiem. (4:57:26 PM) |
hh:mm | Time with hour, minutes, and meridiem. (04:57 PM) |
h:mm | Time with hour in a single digit, minutes, and meridiem. (04:57 PM) |
HH | Hours in 24 hour time format (00-23) |
H | Hours as a single digit in 24 hour time format (0-23) |
hh | Hours in 12 hour time format (01-12) |
h | Hours as a single digit in 12 hour time format (1-12) |
mm | Minutes in two digits (01-59) |
ss | Seconds in two digits (01-59) |
a | Meridian Indicator (AM/PM) |
zz | Time Zone (Indian Standard Time) |
z | Time Zone in short (IST) |
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
How to insert dates that automatically update to the current date
Overview Zoho Writer allows you to insert dynamic date fields that automatically update to the current date whenever the document is opened or printed. This is useful for creating templates, reports, letters, and documents that always reflect the ...How to create dynamic lists and tables with repeat blocks in merge templates
Overview Repeat Blocks in Zoho Writer’s Mail Merge help you duplicate blocks of content like rows in an invoice or items in a list based on multiple records in your data source. This is useful for generating dynamic documents such as purchase orders, ...How to insert dynamic text links for each record using merge fields
Overview Zoho Writer allows you to insert personalized hyperlinks in your documents by combining static text with dynamic merge field values. This is useful for creating recipient-specific URLs—for example, linking to individual order summaries, ...How to add date based conditional fields in a document
Overview You can now use conditional logic with date fields to show or hide content based on date comparisons, before or after a certain date, and display values only for records within a specified time window. Here's an example: Steps A. Add Date ...How to customize date field format in merge template
Overview Zoho Writer allows you to customize the format of date fields in merge templates, so the final document displays dates in the preferred style—whether that's 25 July 2025, 07/25/2025, 25-07-2025, or even localized formats like 25 जुलाई 2025. ...