2. PHPRunner General questions
  3. [SOLVED]  Search date-fields with german input-format
This topic is locked
[SOLVED]

 Search date-fields with german input-format

 		9/2/2013 08:42:58
PHPRunner General questions
T
 taumic author

PHPRunner 6.2
In mysql database tables the date format is "YYYY-MM-DD". So the date-field is stored as "2013-09-02".

On the PHPRunner MISC-Page the regional setting is "Deutsch" (= German).

When I search for a date-field, (in germany we write the date as "02.09.2013") via a PHPR-Programm I always get the message "No records found".

What I have to do, to get the right result? Is there anywhere a switch in PHPR, so PHPrunner is formating my searching?

(select date_format(_datefield, "%d.%m.%Y") as _date from _database)
Best regards
Michael
C
 		cgphp 9/2/2013

Please, make sure the date field is using the right regional setting: http://xlinesoft.com/phprunner/docs/edit_as_settings_date.htm
T
 		taumic author 9/2/2013

The datefield is setting as "readonly", but when I click on "Edit as DATE" I can see the setting is DD.MM.YYYY (german).

Do not get me wrong, the problem is not the view, but that the date-field is not found.

Thank you for your fast reply.
Michael
C
 		cgphp 9/2/2013

Is it set as readonly or date? If you set as date you will able to make a correct search. If you set as readonly phprunner doesn't apply the localization conversion.
T
 		taumic author 9/2/2013

Thank you Christian, for that important information!

Now I set it as a date and i get a successful operation.
Best regards!
Michael