Dear Support
Thank you very much for helping us for always.
My name is Takasumi and I am reseller of ZohoCRM in JAPAN.
Currently I am implementing ZohoCRM for my customer in Japan.
We need to calculate several date related with invoice data in ZohoCRM Account page.
Customer A[Account]
Need to automatically calculate Invoice date using Formula field(Custom field).
Would you kindly inform us how to retrieve following date by formula.
Please give us actual sample of formula.
A) Formula which return end of month.
If today is 2012/03/08, we would like to retrieve 2012/03/31
as end of month.
B) Formula which return Next month day 10.
If today is 2012/03/08, we would like to retrieve 2012/04/10
as Next month day 10.
C) Formula which return Next month day 15.
If today is 2012/03/08, we would like to retrieve 2012/04/15
as Next month day 15.
Best Regards
Takasumi Shindo
SaaS&CRM Consulting.,Ltd
Zoho Japan reseller.