/****** Script for SelectTopNRows command from SSMS ******/

SELECT TOP 1000 [ServerName]

,[IsExisting]

,[IsEnabled]

,[IsScheduleEnabled]

,[NAME]

,case when CONVERT(date, CONVERT(VARchar(18), 'LASTRUNDATE'))='0' then NULL else CONVERT(date, CONVERT(VARchar(18), LASTRUNDATE)) end as lastrundate

,[Date]

FROM [Monitor].[dbo].[Job_Monitor]

plz help

error

Msg 241, Level 16, State 1, Line 4

Conversion failed when converting date and/or time from character string.