Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neostar
Starting Member
18 Posts |
 Posted - 2006-01-30 : 11:02:50
|
| I have a table in sql 2005 where by one of the fields uses the GETDATE() function as the default value. The field datatype is datetimeI'm trying to create a report that has a date picker paramter that refrences the date field in the table so records are returned based on the date entered via the date picker.The problem is when ever I pick a date using the date picker on the report that I know has records against it the report still returns no records. Am I doing something wrong? Do I have to convert the datatype first? I'm using the standard UK format dd/mm/yyyy and the report is set to English-GBThanksDan |
|
|
mallykarjuna
Starting Member
5 Posts |
Posted - 2006-01-31 : 06:24:28
|
| U need to convert the date format to 'mm/dd/yy hh:mm:ss tt' then compare with the corresponding field in the table. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-31 : 06:30:50
|
| It is better to format to the Universal format yyyymmdd hh:mm:ssMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Date Picker problem 2005