This topic describes the syntax and usage of the toDate function in Zoho Creator .


The toDate function converts a date that is stored as text to a format that Zoho Creator recognizes as a date. The function will parse the input text and convert it to the date format as specified in the application setting page. It will throw an error if it cannot convert the text to date.





// this format is supported only in the free flow scripting mode of Script builder.

The toDate/dateValue function syntax has the following arguments

string - Required. A string that represents a date. For example, "1/30/2013" or "30-Jan-2008" are text strings within quotation marks that represent dates.


In this example, the date format specified in the application settings page is dd-MMM-yyyy. Hence the date text "05-20-13" is converted as 20-May-2013.

str = "05-20-13";
dat1 = (str).toDate(); // returns 20-May-2013
str = "05-20-13";
dat1 = dateValue(str); // returns 20-May-2013

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: