Datetime

create proc dbo.GetList
(
@OrgList varchar(1000),
@startDateTime datetime 

)
as
begin
 

declare @SQL varchar(1000)
 
set @SQL = 'Select A.TransactionID,
  A.PermitId,
  A.IssuingOrganizationId,
  A.VehicleId

 From Vehicle A WITH (NOLOCK)
  join PurchasingCompany B WITH (NOLOCK)
   on A.PurchasingCompanyId = B.PurchasingCompanyId
 Where
   A.IssueDate >= '+ ‘@startDateTime’ +' And
   A.IssuingOrganizationId IN ('+ @OrgList+')' 
exec(@sql)
end
go
 
This doesn’t work, But If I substitute
@startDateTime with ‘2/1/2004’, it works. I think iam missing some formatting, I tried several ways to make it work. Could anyone tell me how I should do this.