I am looking for some common functions and SQL like command but failed after serching help, blogs and formus. Are those not included yet OR I am not finding as a newbie to Zoho?

 

a. Absolute Number, e.g Abs()

b. Convert a date string('e.g "01-May-2003") to date. I resolved by writing a function myself

c. Convert decimal to integer & vice versa

d. Date difference between dates ( solved alternatively)

e. SQL command like MAX(.eg Salary), MIN(eg Marks), AVG (Salary) and many like these.

 

But many of these functionalities are available in Zoho CRM. Please help me if someone knows how to use it in Creator.

 

MMI