roeya
Posts: 181
|
Posted: 07/31/2006, 7:13 AM |
|
Date fields error in Search Form of a grid
When creating search form for a grid with conditions on date fields such as
after some date or before some date the results are wrong
We found the error when using Perl with SQLite database. The problem is that the date fields in the search form are not converted to the date format of the database itself (As defined in Projects - Settings -Connections -Modify -Server -Date Format: “yyyy-mm-dd HH:nn:ss”)
The value goes directly to the SQL query in the Date format of the field.
To correct this we used the following custom code in the before select event:
CCFormatDate(CCParseDate($value, @DefaultDateFormat), ('yyyy','-','mm','-','dd',' ','HH',':','nn',':','ss'))
This code converts the date to the correct format
We do not know if this error is Perl version only problem or general problem
_________________
http://www.infoneto.com/ |