Date format issue with search

This topic is locked

Date format issue with search	2/11/2012 5:28:58 AM
PHPRunner General questions
A AciXXX author I use PHPRunner 5.3 Build 7474. My project have many mySQL tables and so many DATE fields. It is italian localized: Language: Italian Regional settings: Italiano (Italia) Output Code Page: Europa occidentale (windows) Section 508 compatibility: not flagged Date fields are automatically set as dates in List Page Editor (View as: Short Date is selected) and I correctly see the date as d/m/Y. The problems starts when I try to perform a search on list page by a date field. I must use the mySQL format Y-m-d to be able to search. Is there a way to sove this issue, for example by adapting the searched date to mySQL pattern when the user click on search button (or other better solutions)? Thank you in advance, Andrea


	kujox 3/3/2012
	I use PHPRunner 5.3 Build 7474. My project have many mySQL tables and so many DATE fields. It is italian localized: Language: Italian Regional settings: Italiano (Italia) Output Code Page: Europa occidentale (windows) Section 508 compatibility: not flagged Date fields are automatically set as dates in List Page Editor (View as: Short Date is selected) and I correctly see the date as d/m/Y. The problems starts when I try to perform a search on list page by a date field. I must use the mySQL format Y-m-d to be able to search. Is there a way to sove this issue, for example by adapting the searched date to mySQL pattern when the user click on search button (or other better solutions)? Thank you in advance, Andrea Not 100% sure on what you're after, i thought PHPRunner swapped the date format round automatically but if yours doesn't for some reason then I would look at using Jquery on the date field when the data in it changes, split it then join it back up as you want it.