This topic is locked

Advanced search on timestamp field

9/18/2009 3:48:12 AM
PHPRunner General questions
yarebbel author

I'm unable to find an earlier post about this, so i fire my question as a new topic.
In my database i store dates as timestamps. Within my app i use custom field to convert values to a displayable format, there's never the need to edit or add records.
In the advanced search page i use a datetimepicker for the timestampfields.
It seems to me that i have to convert values back to timestamp before i can process the page as otherwise no data will show up on executing the seach query.
How do I convert the values returning from the datetimepicker, or 2 pickers if i select the between condition, back to timestamps before processing the seach query ?
Regards,

J
Jane 9/18/2009

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.