2. PHPRunner General questions
  3. Clause WHERE with dates
This topic is locked

Clause WHERE with dates

 		7/27/2008 8:25:46 PM
PHPRunner General questions
G
 gbhmayer1 author

I am using the clause
$strWhereClause=whereAdd($strWhereClause,"days = '"."22/7/2008"."'");
to filter my list page (days is a field in date format (d/M/Y)
but not works...
J
 		Jane 7/28/2008

Hi,
you need to use date in the MySQL format: Y-m-d.

$strWhereClause=whereAdd($strWhereClause,"days = '"."2008-07-22"."'");
G
 		gbhmayer1 author 7/28/2008

Hi,

you need to use date in the MySQL format: Y-m-d.


Ok, works fine now
thank you Jane