Power Query - Accessing Cell Value to Power Query

[gaganbansal97]

I have this below line of code. I have made a table with the name DateInput and it has column Date 

Source = Sql.Database("-----", "---", [Query="select * FROM --- WHERE WeekEnd = 'Excel.CurrentWorkbook(){[Name="DateInput"]}[Content][Date]{0}'"]),

It's showing the error as Toek Comma Expected. While clicking on error it's highlighting DateInput

[artemus]

Since the item is a date type, you would need to wrap Excel.CurrentWorkbook(){[Name="DateInput"]}[Content][Date]{0} inside a Text.From

that is:

Text.From(Excel.CurrentWorkbook(){[Name="DateInput"]}[Content][Date]{0})

[artemus]

Try this:

Source = Sql.Database("-----", "---", [Query="select * FROM --- WHERE WeekEnd = '" & Excel.CurrentWorkbook(){[Name="DateInput"]}[Content][Date]{0} & "'"]),

[gaganbansal97]

After using this, it's showing below error

Expression.Error: We cannot apply operator & to types Text and DateTime.
Details:
Operator=&
Left=select * FROM ----
WHERE WeekEnd = '
Right=3/18/2023 12:00:00 AM