Power query question

[Jing]

I have the following query and i am trying to find a way to have it pull the date range for start and end dates from cells within the workbook but am not sure how to do that...

= Sql.Database("server name", "data info", [Query="SELECT Group_Name, Interval_DateTime#(lf),R_ReqHrs as [Original Req Hrs]#(lf),R_advFlex as WeekOutRamp#(lf),R_DayFlex as DayOfFlex#(lf),R_AdjReqHrs as AdjustedReqHrs#(lf),R_FlexHrs_Total as TotalFlexHrs#(lf)FROM FINAL#(lf)where [B][U]Interval_DateTime >= '2022-10-11' AND Interval_DateTime <= '2022-10-18'"])[/U][/B]

Right now it is manually entered into the query but if i can get the dates to change from say start date = A1 and End date = B1 that would be amazing!

 

[GraH]

Load each of the cell (for instance using named ranges) into PQ as a separate query. Be sure to drill down on the value.
Then refer to these querynames as parameters in the string you build.