CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> Perl

 Date fields error in Search Form of a grid and solution

Print topic Send  topic

Author Message

Posts: 180
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

View profile  Send private message
Last Hero
Posted: 08/01/2006, 2:47 AM

Do you have right settings in datasource where parameter?
FieldType = Date

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by  and YesSoftware, Inc.