02/11/2010 6329 views
What date format do I need to use to create a custom filter in the Help Desk module e.g. tickets opened after 1/1/2010?
I'm a newbie to KBOX, so apologies if this is a silly question. [:)]

0 Comments   [ + ] Show comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

You may try the format like this '1990-10-02' i mean 'yyyy-mm-dd' in the WHERE clause
Answered 02/11/2010 by: afzal
Fourth Degree Green Belt

The standard date format for the US in MySQL is YYYY-MM-DD.
Answered 02/12/2010 by: airwolf
Tenth Degree Black Belt

And keep in mind that most dates are stored in our database as timestamps. So when you say >2010-01-01 you are actually saying >'2010-01-01 00:00:00'. This mean you are effectively including Jan 1st because 00:00 is midnight.
Answered 02/12/2010 by: GillySpy
Seventh Degree Black Belt