2. PHPRunner General questions
  3. Date Search Issue
This topic is locked

Date Search Issue

 		3/9/2006 10:08:53 AM
PHPRunner General questions
prleo1 author

Sergey,
When using the Search and Advanced Search for date columns, I have noticed that you have to type in the MySQL formatted date in order to retrieve any records. For instance, I need to enter 2006-03-01 instead of 03/01/2006. This is also the case in the advanced search.
PR
T
 		Tommy B 3/10/2006

Be sure your edit as field type is date. You could even include the datepicker if you want.
prleo1 author 3/10/2006

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8465&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />--><div class='quotetop'>QUOTE(Tommy B @ Mar 10 2006, 01:33 PM) <{POST_SNAPBACK}></div><div class='quotemain'><!--quotec-->

Be sure your edit as field type is date. You could even include the datepicker if you want.

[/quote]
Tommy B,

The field is set to date; actually, mm-dd-yyyy format w/ data picker. Even if you use the datepicker to select the date, the query will come up with an empty result set. In order for the date search (Search and Advanced) to function correctly, you have to put the date search in yyyy-mm-dd format (with the hyphens).