Hi Experts (note this is a follow on question from)
I have know been to the SQL guys and they have said the following
and fos_datetime_new_op is not null
gives 0 rows.
So I would say that the issue is the null values. If your script filters out the null values, it should then work.
The date in the field is in the format: ‘2011-11-21 15:30:30.383’
I am still tying to resolve the issue
CAST(CONVERT(varchar(8), [fos_datetime_new_op], 112) AS datetime) AS [fos_datetime_new_op],
CAST(CONVERT(varchar(8), [fos_datetime_closed_op], 112) AS datetime) AS [fos_datetime_closed_op],
MY QUESTION IS HAVE THE SQL GUYS HERE ON MY SIDE TOLD ME ANYTHING NEW....the EE genuis have not all ready previous told me,,,,,in getting this resolved?