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







                            Zoho Developer Community





                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner






                                                            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 Writer

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ








                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • Add Webhook Response Module to Zoho Flow

                                                                                                              Hi Zoho Flow Team, We’d like to request a Webhook Response capability for Zoho Flow that can return a dynamic, computed reply to the original webhook caller after / during the flow runs. What exists today Zoho Flow’s webhook trigger can send custom acknowledgements
                                                                                                            • Triggering Zoho Flow on Workdrive File Label

                                                                                                              Right now Im trying to have a zoho flow trigger on the labeling/classification of a file in a folder. Looking at the trigger options they arent great for something like this. File event occurred is probably the most applicable, but the events it has arent
                                                                                                            • Bidirectional sync between Zoho Bookings and Zoho CRM - Part 1

                                                                                                              Hey, community members! The default integration between Zoho CRM and Zoho Bookings is unidirectional, which means that any appointments booked, rescheduled, or deleted in Zoho Bookings will be reflected in Zoho CRM. However, any modifications made to
                                                                                                            • Is it possible to edit placeholder text?

                                                                                                              In the master slides I want to make sure my templates have more meaning for the users and want to replace the standard placeholder text with something more instructional. Instead of "Click to edit Mast subtitle styles" I want to have "Click to enter reporting
                                                                                                            • Delay function execute

                                                                                                              I've got a workflow which uses a webhook to send information to Flow, which in return updates a record in Creator. Problem is, by the time this has executed, the rest of my script has run and can't find the (yet to be) updated info in the record. Is there
                                                                                                            • Refunds do not export from Shopify, Amazon and Esty to Zoho. And then do not go from Zoho inventory to Quickbooks.

                                                                                                              I have a huge hole in my accounts from refunds and the lack of synchronisation between shopify , Amazon and Etsy to Zoho ( i.e when I process a refund on shopify/ Amazon or Etsy it does not come through to Zoho) and then if I process a manual credit note/
                                                                                                            • How to allow download of a file AFTER information is collected?

                                                                                                              I can't find this anywhere. Can someone help with what seems to be a pretty basic web function today? - File is stored in Workdrive - Prospect goes to a URL where the file is located - System requests prospect to enter "Name" and "Email" - An email is
                                                                                                            • Email Reminders on Shared Calendars

                                                                                                              How do we turn off the setting that emails reminders to everyone who has accepted or declined a calendar invite? If 8 of us have been invited to the same meeting, we receive 8 notifications for every step of the process, from invitation to decision.
                                                                                                            • Add Baseline methods to API

                                                                                                              There are no API methods for creating or querying baselines,  Use case: Customer is notified of the current project start date according to plan via another product/integration. We would like to auto create a baseline (Automated via API) at the point
                                                                                                            • Bulk Fill In & Edit PO/Bill/SO/Invoice

                                                                                                              Hello, I am adding stock in bulk on a PO, the system is automatically populating the Rate (price) and Tax from the item data. Problem is that the bill rate is different from the rate on the item data, so I have to manually erase each and enter the price.
                                                                                                            • Fixed Assets beg balance

                                                                                                              Hello, I trust you are well I'm a new zoho books user and I find it difficult to plug in the fixed assets balance and here's what I have done: 1- I imported the fixed assets data into the fixed assets module as per the instructions 2- the import process
                                                                                                            • Syncing with Google calendar, Tasks and Events

                                                                                                              Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning
                                                                                                            • CRM Deluge how can link attach file with workdrive file.

                                                                                                              Hi, We have create file at workdrive and would like to link to attachment at crm module by deluge. Right now can only upload it to attachment but can not link the file from workdrive. Thank you
                                                                                                            • Feature announcement: AI-powered document generator in Zoho Sign

                                                                                                              Hi there! We recently announced manual document creation by offering an editor within Zoho Sign. Today, we are excited to announce AI-powered document generation to help you draft agreements, purchase orders, and other important business documents in
                                                                                                            • Permanently deleted files

                                                                                                              Is there a way to get back permanently deleted files from your account if they were accidentally deleted and no longer recoverable from the recycling bin? I know I am probably screwed but I just figured I would ask.
                                                                                                            • Shared Mailbox in iOS app

                                                                                                              Hi, On the desktop I am using a Shared mailbox for our company's general mailbox that somebody else should be able to view. In the iOS app however I can't find it? Old sources on the internet says this isn't possible but that can't be right? Somebody
                                                                                                            • Tip #41- Simplify Compliance and Efficiency with Zoho Assist’s Data Cleanup Feature- 'Insider Insights'

                                                                                                              Managing device data efficiently is just as important as securing remote access. With Zoho Assist’s Data Cleanup feature, admins can easily remove outdated or unnecessary device records, keeping the console organized and secure. This action is carried
                                                                                                            • Revenue Management: #6 Revenue Recognition in Professional Services Industry

                                                                                                              If you run a consulting firm, agency, or any service-based business, you have a situation where you have signed the contract, maybe even sent the invoice, and have received some initial payments. So, can you consider this as revenue? What if the project
                                                                                                            • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

                                                                                                              I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the
                                                                                                            • Zoho fsm scheduled maintenance dispatch

                                                                                                              Hi, I'm reaching out regarding an issue I'm encountering with the Scheduled Maintenance feature in Zoho FSM. I’m trying to configure it so that it automatically dispatches all maintenance jobs scheduled within the next 150 days, starting from today. However,
                                                                                                            • Template modifiactions

                                                                                                              Hello, I am struggling with the templates in ZOHO Books. Especially with the placement of some items, like company address, ship to, bill to etc.  For example: One item I like from template X (placement of ship to and bill to next to each other in the
                                                                                                            • zoho.inventory.getRecords returns no records

                                                                                                              I running a custom function (Deluge) in Zoho Flow with a connection to Zoho Inventory. To debug the problem, I created the test function below. It returns "Number of contacts fetched: 0". This confirms that there's no issue with the org ID or connection
                                                                                                            • How do I get Status History data of my Projects?

                                                                                                              I want to build a table in Zoho Analytics that Groups by Date, when Projects entered a certain status. I cannot find Status History or any such useful data available in the Setup of my Data Source sync. Please advise how I can achieve this?
                                                                                                            • Zoho Campaigns Event timestamps do not propagate to Zoho CRM

                                                                                                              We have integrated Zoho CRM and Zoho Campaigns. But when looking at Contact records, the Campaign event data is missing the actual timestamps: especially when a particular email was sent. They're not in the Campaigns related list, and the cannot be found
                                                                                                            • Feature announcement - Simplifying document creation with Zoho Sign

                                                                                                              Hi there, We are pleased to announce the release of our document creation feature, enabling you to create, edit, and finalize documents like agreements, purchase orders, and contracts without relying on external tools or applications. <br> This
                                                                                                            • Integrating File Attachments in Zoho Flow Email Notifications

                                                                                                              Hi, I would like to be able to send an email once an entry is made in a form, and in this email, I would like to attach a file that has been added to the form using the ImageUpload (or FileUpload) widget. So, I started by creating a flow that will trigger
                                                                                                            • CRM->INVENTORY, sync products as composite items

                                                                                                              We have a product team working in the CRM, as it’s more convenient than using Books or Inventory—especially with features like Blueprints being available. Once a product reaches a certain stage, it needs to become visible in Inventory. To achieve this,
                                                                                                            • Zoho Mail SMTP IP addresses

                                                                                                              We are using Zoho Mail and needs to whitelist IP for some redirections from your service to another e-mails. You can provide IP address list for Zohomail SMTP servers?
                                                                                                            • Zoho project purchases

                                                                                                              Hi Folks, I think having a purchase module in projects will help in putting together a project p and L. Project wise purchases and expenses.  Do let me know your thoughts.
                                                                                                            • Create Tasklist with Tasklist Template using API v3

                                                                                                              In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to
                                                                                                            • How can I restore all the deleted Time entries of a Task in Zoho Projects

                                                                                                              How can I restore all the deleted Time entries of a Task in Zoho Projects? Query: In Zoho Projects, I cloned a task and deleted the time entries from the cloned task. However, this also deleted the time entries from the original task. How can I restore
                                                                                                            • Is there a way to make an account inactive in ZoHo Desk

                                                                                                              We have a few Clients "Accounts" that we no longer do business with. It would be beneficial for them to not show up in lists. However, we want to go back and view tickets, time, etc.
                                                                                                            • How to set the value of the Phone field importing contacts in Zoho Desk

                                                                                                              Hi everyone, i'm new in Zoho Desk, we're setting up the environment and i'm importing contacts from another CRM using a file CSV and i'm getting a problem with phone numbers (italian): the leading zero is cut away, also if the value is inside double quotes.
                                                                                                            • Can we generate APK and IOS app?

                                                                                                              Dears, I want to know the availability to develop the app on zoho and after that .. generate the APK or IOS app  and after that I added them to play store or IOS store.. Is it possible to do this .. I want not to use zoho app or let my customers use it. thanks 
                                                                                                            • Set Custom Icon for Custom Modules in new Zoho CRM UI

                                                                                                            • Change total display format in weekly time logs

                                                                                                              Hi! Would it be possible to display the total of the value entered in the weekly time log in the same format that the user input? This could be an option in the general settings -> display daily timesheet total in XX.XX format or XX:XX.
                                                                                                            • Deprecation Notice: OpenAI Assistants API will be shut down on August 26, 2026

                                                                                                              I recieved this email from openAI what does it means for us that are using the integration and what should we do? Earlier this year, we shared our plan to deprecate the Assistants API once the Responses API reached feature parity. With the launch of Conversations,
                                                                                                            • How to center a field inside a section?

                                                                                                              I’ve been trying to center a field inside a section in Zoho Canvas. When I align it visually, it looks centered in the editor, but after clicking Save, the field appears misaligned on the actual canvas. I also tried setting the field to full width, but
                                                                                                            • Kaizen #192 - Implementing Custom Token Persistence in Python SDK

                                                                                                              Welcome back to another week of Kaizen! Last week, we discussed how to implement Login with Zoho using OAuth 2.0 and saw how to bring it to life in a real-world application with the Zoho CRM Python SDK. We also discussed how Zylker Academy built a custom
                                                                                                            • Showing the map along with mileage expense

                                                                                                              When you use the GPS to track mileage, it shows you the map of the actual path travelled. It would be very useful and practical to save that map with the mileage expense, so that when the report is created, it provides a map of each mileage expense associated
                                                                                                            • Next Page