Hi, Zoho Support. Good day.

I have read your docs regarding COQL but I cannot find anything related to fetching the current date in COQL. Can someone please help me with this or is this even possible in Totango Integration?

What I need is the correct syntax for the query filter in Totango Integration to fetch the current_date. Below is my query filter:
(Status = 'Activated Contract' AND Company_ID is not null) AND Contract_End > CURRENT_DATE

I got this error when I am using CURRENT_DATE:
error: 'value given seems to be invalid for the column' while executing the query

Please help. Thank you.