I have used the below, and it returns results, obviously I have it between quotes
SELECT TOP (10000) [LogID]
,[ParentLogID]
,[Description]
,[PackageName]
,[PackageGuid]
,[MachineName]
,[ExecutionGuid]
,[SystemIdentifier]
,[LogicalDate]
,[Operator]
,[StartTime]
,[EndTime]
,[Status]
,[FailureTask]
FROM [ssisLogger].[logging].[executionLog] where PackageName in (‘RGLRec_ETL_Master’ , ‘RGLWalker_ETL_Master’) AND StartTime >= ‘2020-06-02’
Now all I want to do is change the date for a variable containing the date.
"SELECT TOP (10000) [LogID]
,[ParentLogID]
,[Description]
,[PackageName]
,[PackageGuid]
,[MachineName]
,[ExecutionGuid]
,[SystemIdentifier]
,[LogicalDate]
,[Operator]
,[StartTime]
,[EndTime]
,[Status]
,[FailureTask]
FROM [ssisLogger].[logging].[executionLog] where PackageName in (‘RGLRec_ETL_Master’ , ‘RGLWalker_ETL_Master’) AND StartTime >= " + “'” + Today.Tostring + “'”
but keeps telling me it needs to end in double quotes, I have done this before but I can’t find my previous work