Hi I have created dynamic M query which passes input slicer (i.e start date and End date)
The Query i have writen as below
filterquery = "SELECT * FROM Schema1.TabName where ""date"" >= '" & DateTime.ToText(StartDate,"yyyy-MM-dd") & "' And ""date"" <= '" & DateTime.ToText(Date.AddDays( Enddate,1),"yyyy-MM-dd") & "'"
Here I have created start date and end date parameters as “Date/time” format and bind to parameters from slicer tables.
Now i am unable to convert them as calander date picker,any modification need to be done in above Query?