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,