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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-10 : 08:16:45
|
| Mark writes "I am trying to get a datetime field to become 4 seperate parameter (BeginTime, BeginDate, EndTime, EndDate) fields in Crystal Reports 9 using SQL. My database is SQL Server and I am having a lot of trouble trying to find the code to type. Please help.I have tried:((Master.DateTime) Between ({?BeginDate} + ({?BeginTime})) And ({?EndDate} + ({?EndTime}))) Andand it gave me a blank report, no errors (not blank before trying that statement)I have also tried this:((Master.DateTime) Between ({?BeginDate} + timevalue({?BeginTime})) And ({?EndDate} + timevalue({?EndTime}))) Andand I get an error saying timevalue is not recognized.I have no idea how to go about doing this...I have never really used SQL before. Please help" |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-11 : 23:14:44
|
| What exactly are you passing in the parameters {?BeginDate}, {?BeginTime} i.e the value and the format of date and time value.and error is because there is no such function in sql server. |
 |
|
|
|
|
|
Help