Data Formats
Below are are some guidelines for formatting time/date data values as well as function names. Depending on your country/region locale, other formats may be used instead.
Date Formats
MMM DD, YYYY for example: 'Mar 10, 2009'.
YYYY-MM-DD for example: '2009-03-10'.
Time Formats
hh:mm:ss aa for example '9:35:17 PM'.
HH:mm:ss (24-hr Time) for example '21:35:17'.
Date Time Formats
These can be combinations of the date and time formats mentioned above. Here are two such combinations.
MMM DD, YYYY hh:mm:ss aa for example 'Mar 10, 2009 9:35:17 PM'.
YYYY-MM-DD HH:mm:ss for example '2009-03-10 21:35:17'.
Functions
Functions can be passed instead of values. Do not enclose the function name in quotes.
For example you can use the function: now()
See also: