Forum Discussion

royalswe's avatar
royalswe
Helper I
5 years ago
Solved

Dynamic date in Odata query

I am fetching data from Dynamics 365 with OData and I only want to fetch data that is 3 days old or newer.   I have this query and it works but the date is hardcoded as you can see.     = ...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hi,

I want to change date format in Odata query. It is taking value in format YYYY-MM-DD. 

example of Odata query from Microsoft: 

let
Source = OData.Feed ("https://analytics.dev.azure.com/{organization}/{project}/_odata/V3.0-preview/WorkItemBoardSnapshot?"
&"$apply=filter( "
&"Team/TeamName eq '{teamname}' "
&"and BoardName eq 'Stories' "
&"and DateValue ge 2023-10-18 "
&") "
&"/groupby( "
&"(DateValue,ColumnName,LaneName,State,WorkItemType,AssignedTo/UserName,Area/AreaPath), "
&"aggregate($count as Count) "
&") "
,null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls,ODataVersion = 4])
in
Source

Now I want to change it to MM-DD-YYYY, can you please provide your input on this how we can convert this?