CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 WHERE clause for DATE not working

Print topic Send  topic

Author Message

Posts: 16
Posted: 09/05/2007, 6:05 AM

I am using PHP and MS SQL Server.

I have a form that I am trying to limit the display of records to ones between a set of dates.

The record has a field emp_task_timedate which is a date field.
I have created two controls beginDate and endDate which are date fields.
Within the source for the GRID I have created a select statement and I am trying to limit the dates appearing in the grid by using the WHERE clause. I have tried setting the display format, database format, switching the fields to TEXT fields and even using the EXPRESSION version of the WHERE clause with no results. I have tried making the parameter a URL as well as a SESSION variable.

I have even tried to simplify my comparison to emp_task_timedate <= endDate but no matter what I set endDate to on the form it continues to return all records.

Any hints tips advice?

View profile  Send private message

Posts: 1712
Posted: 09/05/2007, 5:18 PM

Have you tried running your sql in MSSQL directly?? Are you sure that your date fields are formatted correctly??
View profile  Send private message

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

Web Database

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.