This topic is locked

Functions in View Where Clause

3/25/2014 6:18:08 PM
PHPRunner General questions
P
PhpApprentice author

I have some views where I had coded:
WHERE (YEAR_ENTERED = 2013)
I would like to change this to something like WHERE YEAR_ENTERED = YEAR($TODAY)
I see that the YEAR() function is available, but am stuck there.
I would also like to read the document of what functions are available in the WHERE clause and what system variables are available.
Thanks,
Larry

F
F5447 3/26/2014

Please try YEAR(NOW())