How to change static date to dynamic date in API, for refreshing data - to current date

[Madhu155154]

Any suggestion on how to change the "end date" from static to "dynamic to the (current) Present date" for capturing the data till the current date, while refreshing it,

Data - I got the data through the API

Current Issue - I am changing the end date manually in the Power Query 

[Madhu155154 · Accepted solution]

I have used the below formula to get the date and  then passed it as a parameter in API, But Thank you for your support and suggestion 

currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),

let

currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),

Source = Json.Document(Web.Contents("https://cs-intmgroservices.io/intmgmtsvc/report/nReport" & "?startDt=2020-01-01&endDt=currentDate",

[Madhu155154]

 @Mahesh0016  , Thank you for replying.

I I, have used  your suggested function in the power query, but  i am getting an error

[Mahesh0016]

@Please Try this. Thank You.
endDt
= #date(
Date.Year(DateTime.Date(DateTime.LocalNow())),
Date.Month(DateTime.Date(DateTime.LocalNow())),
Date.Day(DateTime.Date(DateTime.LocalNow()))
)

[Madhu155154]

  I have used  your suggested function in the power query, but  still I am getting an error

[Mahesh0016]

@Madhu155154  please try this one.
endDt=

Date.ToText(#date(Date.Year(DateTime.Date(DateTime.LocalNow())), Date.Month(DateTime.Date(DateTime.LocalNow())), Date.Day(DateTime.Date(DateTime.LocalNow()))), [Format="YYYY-MM-DD", Culture="en-US"])

[Mahesh0016]

@Madhu155154 I hope this helps you. Thank You.

endDt = DateTime.Date( DateTime.LocalNow() )