Forum Discussion

FlowViz's avatar
FlowViz
Helper III
4 years ago
Solved

Dynamic date range in OData query

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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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's avatar
mahoneypat
Microsoft Employee
4 years ago

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