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


Please log in to comment

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


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

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

Please log in to comment
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

Please log in to comment
Answer this question or Comment on this question for clarity