Forum Discussion
Hand over date from last year to URL
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!
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
4 Replies
Hi,
In your formula try replacing DateTime.LocalNow to DateTime.LocalNow().Hi,
that was one of my mistakes, thanks!
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
Thank you!
