Forum Discussion

FlowViz's avatar
FlowViz
Icon for Helper III rankHelper III
5 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
    5 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

ponnusamy's avatar
ponnusamy
Icon for Solution Supplier rankSolution Supplier
5 years ago

FlowViz 

 

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

FlowViz's avatar
FlowViz
Icon for Helper III rankHelper III
5 years ago

Amazing thank you!