But basically the user enters in a date and i've incorporated it to run as an SQL statement.
The bizarre thing is: i can search the database providing a date (and
display the results) most of the time successfully with no problems. There's
only 15 entries in 'photo' table - it has a couple of entries for the date
10/01/2000. But when i try and find these, i get nothing back... why would
To test it out yourself... look at some of the dates (phDate) in the 'photo' table. Try some SQL queries to return information based on a chosen date.
Select * from photos where phDate = #10/01/2000#
Any feedback or suggestions would be much appreciated.