Viewing 3 posts - 136 through 139 (of 139 total)
I also tried
Case
When Start > 0 Then Convert(smalldatetime,Start)
Else 0
End
As Job_Start
June 9, 2009 at 2:01 pm
#1007039
Okay, I know this should be easy since I figured out the convert in the first place.
But... I can't seem to get it to work.
What is the proper syntax for...
June 9, 2009 at 1:58 pm
#1007035
Unfortunately Start and Close are in YYYYMMDD format.
Which is why I convert them to a string to strip out what I need.
June 9, 2009 at 1:33 pm
#1007022