Joe
|
| Posted: 08/26/2004, 6:18 AM |
|
I have been using CCS for about 8 months I had the date range search down, then I upgraded CCS with the recent upgrade, now my dates searches do not work, when I try to put them together, now I am not talking about the old one, I am creating a new date range from scratch. Here is the problem. When I try to search a date range of the same day it works fine, but when I do any other date range I get data from the year before date range. Example. I search 8/01/2004 - 08/16/2004 I get all the data between the dates but also 2003 between the dates, please help.
CCS, ASP, MS SQL
Thanks
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 08/31/2004, 4:34 AM |
|
Joe,
Please check the settings date search field WHERE parameter under Grid’s Data Source dialog. Here are sample common settings:
E.g.
Field
Name: DateFieldName
Type: Date
Format: select/type in the date format in which date are actually stored in a table. E.g.: dd/mm/yyyy
Operation: =
Parameter Source
Name: s_DateFieldName
Type: URL
Format: select/type in the format in which date is passed via URL. E.g: m/d/yy
If you set Default Value make sure that its format is the same as Format property of s_DateFieldName field on a Search form
You can also print generated query from Before Execute Select event and test the query in Query Analyzer. It helps you to find out what is wrong with WHERE parameters.
_________________
Regards,
Nicole |
 |
|
|
