Forum Discussion
Updating date in Query daily
I have the following Query, which has pulled historical data from a database for the last 7 months into Power BI. Query="SET NOCOUNT ON#(lf)DECLARE @StartDate DateTime#(lf)DECLARE @EndDate DateT...
Anonymous try this
SET NOCOUNT ON DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = ( SELECT CONVERT(DATETIME, CONCAT ( CONVERT(VARCHAR(4), YEAR(GETDATE())-1) ,'-' ,CONVERT(VARCHAR(2), MONTH(GETDATE())-1) ,'-' ,CONVERT(VARCHAR(2), DAY(GETDATE())-1) ,' 07:00:00.000' )) ) SET @EndDate = ( SELECT CONVERT(DATETIME, CONCAT ( CONVERT(VARCHAR(4), YEAR(GETDATE())) ,'-' ,CONVERT(VARCHAR(2), MONTH(GETDATE())) ,'-' ,CONVERT(VARCHAR(2), DAY(GETDATE())) ,' 07:00:00.000' )) ) SET NOCOUNT OFF
