Dynamic date filter in web content source

[kata]

Hi All,

We are connecting to JIRA data, which is working fine with the following code:

What I would like to reach is to have a dynamic date range, and have the data from the first day of the current year untill the current data.

I have tried to put after the "from" and after the "to" the following:

content=
"{



""from"": "&Date.ToText(Date.From( Date.StartOfYear(DateTime.Date(DateTime.FixedLocalNow()) )),"yyyy-MM-ddT00:00:00Z" )&",
""to"":"&Date.ToText(Date.From( Date.EndOfMonth(DateTime.Date(DateTime.LocalNow()) )),"yyyy-MM-ddT00:00:00Z")&"

}",

But unfortunately it did not work, and I am not too good at M code.

Can you please advise what should I do? 

Thanks in advance!

[kata]

Dear @amitchandak ,

Thank you very much for the articles, I read them but honestly I do not understand still how I could implement in my exact example the dynamic date solution:(

Thank you again

[amitchandak]

@kata , refer if these can help

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...