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

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

Yes this is what I'm seeing:

 

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
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