Failure to convert datetime from character error

[PPetronas]

Hi,

I have the below SQL query in Creports. It is throwing an error " Conversion failed when converting datetime from character string".

Declare @Get_Date datetime, @StartDate Varchar(30)

select @StartDate = '{?StartDate}'

Select @Get_Date = convert(varchar ,month(Getdate()) )+ '/01/' +convert(varchar, year(Getdate()))
Select @Get_Date = dateadd(m,datediff(m,0, convert(datetime,@StartDate) ),0)

I think I am missing something. Any ideas?

Thanks,
Petronas

 

[Madawc]

It's not clear what you're after: also there is a separate SQL forum and it would be better to ask there for something that's purely about SQL.

Still, since you have posted, this is something I wrote in SQL that worked OK and may be useful:

Set @ArMax01= '10-' + Convert(Char(2), DatePart(Month, @LastMonth)) + '-' + Convert(Char(4), DatePart(Year, @LastMonth))

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10