The many ways to use the new Date field options in Writer!

The many ways to use the new Date field options in Writer!

With the all-new date field options, you can forget about manually calculating your past, present and future dates and leave it all to Writer to automatically calculate it for you.

1. To insert today's date:
If you're writing a letter, you'll likely want to include the current date to show the day it was sent. However, since you could be drafting the letter today but sending it a week later, it's important that your date field updates automatically to the current date.  To do this go to Fields > Date > Dynamic Today's Date. 




2. To display a future or past date:

Future date
Say you're drafting a payment reminder letter to let your subscribers know that the payment deadline has been extended 25 days from the original due date. Instead of calculating the extended due date manually, you can simply input +25 and Writer will automatically input the date into your letter.

To do this, go to Create Custom Date Field. In the Preset date value field, enter your original due date (let's say it's 06/29/2021). 
Now to convert this due date to the extended date, all you have to do is add 25 days in the (+)Add days option below. Writer will then automatically calculate this date for you.



Past date

Similarly, if you wanted to include a past date from your original due date, you can just enter the days you want to subtract from your original due date. To do this, go to Create Custom Date Field. In the Preset date value field, enter your original due date (we'll use 06/29/2021 again).

Now to convert this due date to the past date, all you have to do is enter the number of days or month(s) you want in the (-)Subtract days option below. In this case say it's 25 days. Writer will then automatically calculate this date for you.



3. To create a named date field and reuse it
throughout the document:
Now let's say you want to use the extended date field from example 1 in multiple places in a document, so that if you changed the settings for one of these extended date fields it would affect all the other fields as well.

To do this, go to Create Custom Date Field and create the extended date field like how it's shown in example 1. After you've created the field, go to Date >  Custom Autofields > Extended due date and place the fields wherever necessary in the document. Now if you were to change the settings for one of these fields (if perhaps you want to change the extended date field from 25 to 30 days), then this change would be reflected in every other field in the document as well. 




4 (a). To add business dates during document merge:
Payment due dates, submission deadlines, and meeting dates often take place on business days and exclude weekends. To calculate only business dates during document merge, click the settings icon next to Manage Fields and click Configure next to the Date merge field. Now add or subtract the number of days you want, then check the Exclude option and select Weekends.




4 (b). To add business dates for new merge date fields:
If you wanted to create a new merge date field (like an extended date field which is 25 days from your original date) that excludes weekends, go to Create Field.




Now, add the name of the field and choose the format as Date. Click Configure under the Value option.




Select the field value as your original date (as your extended date will be 25 days after). Now enter 25 in the (+) Add days option, then check the Exclude option and select Weekends.




4 (c). To add business dates for particular date fields: 
To add business dates for particular date fields, click on the date field in the template you want to change and the choose the Change for this instance alone option.



Select the Configure option and add or subtract the days you want, then check the Exclude option and select Weekends. 







Like the update? Let us know what you think of this feature in the comments below, and follow us on Twitter to catch all the latest Writer news first.

    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.






                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts





                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner









                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ






                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方




                                                                                                                • Recent Topics

                                                                                                                • Please design a better spam filter

                                                                                                                  Hi Team, While I love Zoho Mail for all the awesome features you have designed - this is the one you need to do a lot of work on - Spam Filter. Your spam categorization seems to be very inefficient - any email containing brand images or a tracking pixel
                                                                                                                • Host not reachable when sending

                                                                                                                  For few partner that I send regular emails now got error and they don't receive emails Temporary failure fam-xxx.hr/185.xx.xx.xxx Host not reachable. Have more than 20 mails in https://mailadmin.zoho.eu/cpanel/home.do#mailSettings/retryEmail please
                                                                                                                • IP flagged as abusive

                                                                                                                  I'm getting the error that 136.143.188.15 is listed as abusive. I've checked with mxtoolbox.com and it is indeed in the list
                                                                                                                • App passwords stop working

                                                                                                                  Some of my app passwords appear to stop working after awhile. Seems to happen every 6 months or so. Just had to change one again for the second time in a year. Is this a bug or a feature? Or perhaps changes are being made on the back end on occasion that
                                                                                                                • Duplicate entries for contacts birthdays

                                                                                                                  Good morning I have recently started to use my Zoho calendar and noticed that there are multiple birthday events showing for some of my contacts. I have checked my contacts and there were duplicates for some contacts which I have now rectified but the
                                                                                                                • Problem: New Email Consistently Failing to Sync/Display in Inbox

                                                                                                                  Recently, I have noticed that my Zoho Email inbox does not indicate I've received a new email, until I go to *another* folder and then return to the inbox. Only then will new emails be displayed. This has happened 100% of the time, during the past few
                                                                                                                • Zoho IMAP Access to mail doesn't sync messages

                                                                                                                  As stated in the topic - I have company account email address setup, and it has ( as in the picutre ) ActiveSync and Imap access enabled. However the messages does not show up while logged in in Zoho Mail however when I log in in thunderbird everything
                                                                                                                • Cliq iOS can't see shared screen

                                                                                                                  Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards
                                                                                                                • Temps working custom view in Zoho Recruit

                                                                                                                  How do you create a custom view of temps working for this week.  I have tried multiple combinations of job status, start date, end date etc but I am unable to find the correct combinations to show the temps I have working this week?? Any suggestions on how I can do this. 
                                                                                                                • Client Scripts similar to CRM?

                                                                                                                  Hi, Is there any plans for Client Scripts to become a feature of Recruit? Feel this will be a great benefit to a number of users. Would be great for example in cases where a Client has banned / blacklisted a Candidate - so that if that candidate is associated
                                                                                                                • Announcing Zoho Sheet desktop app for macOS and Windows (Beta)

                                                                                                                  Hello Sheet users, We know you’ve been waiting for this one. It has always been the top priority on our roadmap to provide a single native desktop app for macOS and Windows that works both online and offline. Today, we are excited to announce that the
                                                                                                                • Automated entries past the current month in a calendar report

                                                                                                                  Hi all, I have an automation problem. I have a form which on successfull entry adds either 5 or 10 more of these entries with a slight change so our customers can see it throug a calendar report on the webiste. The entry put in manually shows up perfectly
                                                                                                                • Billing Status Update

                                                                                                                  Hello Latha, I’m working on a new automation (deluge) to fulfill one of our requirements. In this automation, there is a step to update the Work Order billing status from “Not Yet Invoiced” to “Non-Billable.” I tried to find the API information relevant
                                                                                                                • What's New in Zoho POS - April 2026

                                                                                                                  Hello everyone, Welcome to Zoho POS’s monthly update, where we share our latest feature updates, enhancements, events, and more. Let’s take a look at how April went. Access and manage other web applications in Zoho POS with Web Tabs You can now access
                                                                                                                • Many Zoho POS Issues

                                                                                                                  Can not apply credits from a customers account as a form of payment. It shows that you can but there is a bug that does not execute the action. Reported many times. Can not view Sessions from Zoho POS WebView, throws a JQUERY error Workflows and actions
                                                                                                                • HOW I CAN GET BETA VERSION FOT TESTING

                                                                                                                  HI. ZOHO I AM INTERESTED IN YOUR BETA SOFTWARE TO EXPERIENCE NEW FEATURES.
                                                                                                                • Multiple EAN code for product

                                                                                                                  option to add multiple EAN code for product???
                                                                                                                • Issue adding/changing mobile number for OTP

                                                                                                                  Hi Zoho Community, I’m trying to add or change my mobile number, but I keep getting this error: “We’re unable to send OTP to this mobile number. Please contact support-as@eu.zohocorp.com” Because of this, I can’t verify my number or continue the setup.
                                                                                                                • Zoho Payroll Canada does not work

                                                                                                                  We submitted payroll within the required timelines. The money was withdrawn from our account and our employees have not been paid. Impossible to get a hold of someone at Zoho. I can’t believe the company operates like this. What a bloody disgrace. Shame
                                                                                                                • Enhance Appointment Buffers in Zoho Bookings

                                                                                                                  There was previously a long-standing feature request related to enhancing the way appointment buffers work in Zoho Bookings, but it looks like the original post has been deleted. I am therefore adding a new request that Zoho Bookings adjust how appointment
                                                                                                                • Functionality based URL to find records due today or in the next week

                                                                                                                  I need to construct a URL to filter a view to records where the evaluation is due soon (i.e. in the next 7 days). To me, that includes today, but Zoho has a different opinion. Zoho defines 39 as NEXT_7_DAYS but this gives unexpected results. https://creatorapp.zoho.eu/...#Report:My_Evaluations?Evaluation_due_by_op=39
                                                                                                                • Allow customers to choose meeting venue and meeting duration on booking page

                                                                                                                  My business primarily involves one-to-one meetings with my clients. Given the hybrid-work world we now find ourselves in, these meetings can take several forms (which I think of as the meeting "venue"): In-person Zoom Phone call I currently handle these
                                                                                                                • Event Time Zone in meeting invites are confusing users

                                                                                                                  When sending calendar invites to internal and external users, the first section "Event Time Zone" is confusing people and they are automatically declining events. Can this section please be removed??? It already shows the correct time zone next to the
                                                                                                                • Forwarding without verification

                                                                                                                  Hi, I use Tripit to keep track of all my business travel. I've recently moved over to Zoho and wanted to set up a forwarding rule to send various travel confirmation emails automatically to plans@tripit.com Obviously this is an email address I don't control,
                                                                                                                • Filter by user in Pivot Chart

                                                                                                                  I have a Pivot chart where the data should be filtered by user. The user enters the system and should see only the data that correspond to it. Can anyone help me?
                                                                                                                • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                                  Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24
                                                                                                                • Whatsapp Limitation Questions

                                                                                                                  Good day, I would like to find out about the functionality or possibility of all the below points within the Zoho/WhatsApp integration. Will WhatsApp buttons ever be possible in the future? Will WhatsApp Re-directs to different users be possible based
                                                                                                                • Internal mails on our company domain (managed by Zoho) do not get delivered

                                                                                                                  Hi last week Thursday and Friday a colleague had sent me two emails which did not show up at all in my inbox, spam or anywhere else. What this a problem with Zoho mail in general or did this affect just us? From the forum is reads like many problems had
                                                                                                                • #2 The Tax Talk Nobody Wants to Have

                                                                                                                  "We are also able to manage our GST invoices without worrying about compliance issues. With Zoho Invoice, we are happy, our tax consultant is happy, and so are our customers," rejoices Shivprateek Habib, Partner, Flutterboots Services LLP. That's usually
                                                                                                                • Bulk upload images and specifications to products

                                                                                                                  Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.
                                                                                                                • Workflows fail silently in Zoho CRM and there is no native way to know

                                                                                                                  Workflow automation is honestly one of the biggest reasons my clients choose Zoho. But there is one problem I keep running into across almost every implementation. When a workflow fails, nobody finds out. Email alerts hit daily limits and just stop. Custom
                                                                                                                • Zoho Commerce and Third-party shipping (MachShip) API integration

                                                                                                                  We are implementing a third-party shipping (MachShip) API integration for our Zoho Commerce store and have made significant progress. However, we need guidance on a specific technical challenge. Current Challenge: We need to get the customer input to
                                                                                                                • Is there a way to update bounce domain after verification process has started

                                                                                                                  Hi Zeptomail Team, I've created a domain and we did not update the bounce domain to our custom record... the validation has already started and I am now unable to update the bounce domain. Is there any way to get this updated on the backend without deleting
                                                                                                                • Pre-orders at Zoho Commerce

                                                                                                                  We plan to have regular producs that are avaliable for purchase now and we plan to have products that will be avaliable in 2-4 weeks. How we can take the pre-orders for these products? We need to take the money for the product now, but the delivery will
                                                                                                                • How to Customize the Member Portal Login Page?

                                                                                                                  Hi everyone, I am currently using the default member portal login page for Zoho Commerce, but I feel it looks quite plain and doesn’t align well with my brand's style. I would like to make it more visually appealing, possibly by: Adding custom colors
                                                                                                                • Picklist values out-of-date in Campaigns

                                                                                                                  Hi I use a CRM (Global) picklist set of values for my field "Connection Strength" (see screenshot 1). . I use Campaigns to follow-up and change the Connection Strength value depending on their stage. The picklist values that appear in the dropdown for
                                                                                                                • Refering cell from other sheet

                                                                                                                  Hi, If we want to refer any cell in the same sheet its very easy, like suppose if I want to refer cell A2  in P7 I just need to type =A2 in P7, similarly how can I refer a cell present in different sheet ( I mean refer cell A2 from Sheet1 into Sheet2) Thanks
                                                                                                                • How to keep track of bags, cans, drums of inventory?

                                                                                                                  We buy and sell products that are packaged in bags 🛍️, cans🥫, drums🛢️, etc. with batch numbers. When we get a shipment of one of the products, how do we track we received (say) 10 cans each of 5L of a product and maybe we received 10 cans of another
                                                                                                                • Global/Overall Reports & Dashboards in Zoho Sprints

                                                                                                                  Hi, Do we have an option to refer Global Level Reports & Dashboards in Zoho Sprints? We could see that we have Project specific Reports & Dashboards inside every Project. However, for a management level we want Reports & Dashboards visibility at a Global
                                                                                                                • Important Update: New Fields Addition in Zoho Sprints Integration

                                                                                                                  We'd like to inform you of an upcoming update to the 'Timesheets' module in the Zoho Sprints integration from June 3, 2026. To enhance time tracking and reporting accuracy for the Zoho Sprints integration, three new fields - Log Type, Meeting ID, Release
                                                                                                                • Next Page