Forum Discussion

kata's avatar
kata
Frequent Visitor
3 years ago

Dynamic date filter in web content source

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!

 

 

2 Replies