Zoho Writer Mail Merge - Create Merge Fields - Date Adjustment Not Working
In Zoho CRM Mail Merge Template, there is the option to Create Fields in Date format. I need the date that is displayed in the document to be the date from CRM (eg 31/12/2020) plus 6 months. So I put 6 months in the date adjustments. However, the result is coming out 01/07/2021 (instead of 30/06/2021). Similarly when I had 31/11/2020 plus 6 months, the result was 02/03/2021 instead of 28/02/2021. How do I fix this so it gives me the actual 6 or 3 months later date?