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 |
|
Cats Solutions
Starting Member
6 Posts |
 Posted - 2006-06-16 : 07:27:22
|
| Hi all, we have a SQL 2000 database which is for recording job information. we are trying to do a sharepoint page that will show all outstanding jobs with conditionl formating to hilight overdue jobs red. we have managed to do this by date with no problem but we are unable to do this by time.We have created a view that sharepoint looks at for the needed fields. the job due time field only has the time entered in which means the default date of 01/01/1900 gets entered by the system.we need away that the only the time is outputted in the sharepoint view and a way to apply conditional formatting to this field in sharepoint and a way to compare the this time to the current system time.I hope this makes sense, as we are complete novices when it comes to SQL. Please ask if you need any more information.Any help or a point in the right direction would be deeply appriciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-16 : 17:01:07
|
| see convert function. for exampleselect convert(varchar(10), getdate(), 112)Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
SQL with Sharepoint