eomonth function not working properly

eomonth function not working properly

Dear ZOHO ,

 

while using Date-Time functions in zoho creator I noticed that the eomonth() function is not working properly.

It returns wrong values for dates in February.

If February has 29 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.02” / 2 nd of March and

if February has 28 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.03” / 3 rd of March.


Best Regards

Michael