Date-based conditions and filters

Date-based conditions and filters

Configure conditions with date 

Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the conditions are met.

Filter records by date 

Use a conditional operator to filter records in your data source to match only specific criteria each time you run merge. 

Here are a few instances of filters by date which might be useful while your data source has a large amount of data:
  1.  Filter records before/after a specific date
  2.  Filter records between two dates. Click here to learn how.
  3.  Filter the mail merge records such that only records with a date that is within 45 days from today.
Please head to our help to learn more about date-based conditions. 
We'd love to hear your feedback. Drop us a comment here, or write to us at to let us know what you think.
Happy merging!

    • Sticky Posts

    • Introducing group by, aggregation, and repeating regions in mail merge templates

      Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now
    • Easily create personalized Writer documents in bulk with your Zoho Creator data

      Hi everyone, We're excited to share that we've added Zoho Creator as a data source for mail merge templates in Zoho Writer. Zoho Creator is a powerful low-code application that collects different types of data. By configuring Creator as a data source
    • Introducing Zoho Writer's new ChatGPT extension

      Hi everyone, We're happy to unveil the ChatGPT extension for Zoho Writer. Now, harness the power of AI to elevate your writing and enhance your productivity. Seamlessly integrate ChatGPT with Zoho Writer so you can chat with the bot and use its responses
    • New in Writer: Write in Arabic, Hebrew, and Other Right-to-left Languages

      We're happy to introduce complete support for right-to-left languages like Arabic, Persian, Hebrew, and Urdu. This update opens Writer to more than 300 million people in 20 countries across the world, and we couldn't be more excited.   Here's everything that's new, improved, and fixed:   I. Enhanced Writing Experience    Working with bullet points, punctuation, even comments and tracking changes—we've refined and rewritten so many little things to enhance your writing experience in all right-to-left
    • Visualize Charts Using Groupby and Aggregate functions

      Hello!   Have you been using tables to present data in mail merged documents? If so, it maybe time to try a more interesting alternative. Charts help you present data in an exciting way, and make it easy to highlight specific aspects of your data.   With