Hand over date from last year to URL

[DocDri]

Hello,

what I want to do is to hand over the date from last year (-365 days) to a URL as text for my web source. As I'm pretty new to power query I tried this:

Source = Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Text.From(Date.Year(Date.AddDays(DateTime.LocalNow,-365))) & "-" & Text.From(Date.Month(Date.AddDays(DateTime.LocalNow,-365))) & "-" & Text.From(Date.Day(Date.AddDays(DateTime.LocalNow,-365)) & "&limit=500")))

But that does not work. Whats the best way to solve this?

Many thanks in advance!

[ppm1 · Accepted solution]

Please try this syntax instead.

= Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Date.ToText(Date.AddYears(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&limit=500"))

Pat

[DocDri]

Thank you!

[ouaelaam]

Hi,

In your formula try replacing DateTime.LocalNow to DateTime.LocalNow().

[DocDri]

Hi,

that was one of my mistakes, thanks!