Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataset date as parameter

Hi   Im trying to add a parameter for narrowing a a dataset.   = Sql.Database("xxxserver.database.windows.net", "DB", [Query="Declare @DateLoadFromMonthMinus1 as Date; Declare @DateLoadFromYearM...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ，

 

Would you please try the following m query:

 

 

= Sql.Database("xxxserver.database.windows.net", "DB", [Query="Declare @DateLoadFromMonthMinus1 as Date;
Declare @DateLoadFromYearMinus10 as Date;
set @DateLoadFromMonthMinus1= Date.AddMonths(DateTime.Date(DateTime.LocalNow()),-1);
set @DateLoadFromYearMinus10=Date.AddYears(DateTime.Date(DateTime.LocalNow()),-10);
select * from [schema].[table] where THE_DATE > " & paramDateLoadFrom & ""])

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai