Dynamic date range in OData query

[FlowViz]

Hey Guys,

I have a query for my dataset that ends in "and ChangedDate ge 2020-02-01Z" I always want it to pull the last 6 months of data from the time of load/refresh. At the minute I'm having to manually go in and change this - I wondered if there was a way I could do this dynamically where it will just always be the last 6 months? 

[FlowViz]

Yes this is what I'm seeing:

[v-jingzhang · Accepted solution]

Hi @FlowViz 

@ponnusamy 's expression has an extra ')' at the end. Remove that and you will get the correct result. There should be only a single ')' there.

Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-6),"yyyy-MM-dd")

Regards,
Community Support Team _ Jing

[mahoneypat]

That expression from @ponnusamy should work.  Does your query look like this?

"... ChangedDate ge " & Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-6),"yyyy-MM-dd")) & "Z"

Pat

[FlowViz]

Unfortunately that didn't work 😞

[ponnusamy]

@FlowViz 

Try this 'and ChangedDate ge "Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-6),"yyyy-MM-dd"))" in advance editor

[FlowViz]

Amazing thank you!