as a test i've set up:

SELECT lessondate,

case

when charindex('day, ',lessondate) > 0

then CONVERT(datetime,right(lessondate,len(lessondate) - charindex(' ',lessondate)),112)

else CONVERT(datetime,lessondate,112)

FROM KPCourseDetails

WHERE coursename =...

Hi There,

Thanks for getting back to me again.

My current query is:

SELECT lessondate, CONVERT(datetime,right(lessondate,len(lessondate) - charindex(' ',lessondate)),112), dateserial FROM KPCourseDetails

WHERE coursename = 'Provide Responsible Service of Alcohol (QLD)' AND timesattempted =...

Hello again!

Yes both formats are stored in the same column (ugh...) and they both need to change. It's horribly frustrating...

table name: KPCourseDetails

column: lessondate

Hi There, thanks for getting back to me! After all the time i spent, you got way further then i did... i feel so average now lol

In the date type...