140
Hi All,
I am using D365 currently, i have a query regarding fetch xml, i need entity data if current date is in between start date and end date then display record.
i tired but not able find the way where i can get current date value.
Can any one help me on this.
Regards,
Jyotsna
*This post is locked for comments
Hi,
Did you check the above workaround of using Today? "how to pass date dynamically in fetch XML" depends upon where are you using the fetch, for example, If it is C# code then you could get the current datetime and then add it to the fetchxml
Hi Ravi ,
Thanks for the suggestion , can you please suggest how to pass date dynamically in fetch XML.
Thanks & Regards,
Jyotsna
Hi,
There is one workaround to achieve this with fetch xml as as well. Refer below screenshot-
Hi,
The only filter related to current date is today which can only be used like <>particular date field> is on "Today". You cannot use today in any other condition.
However if you are using this fetch xml in custom code then you can dynamically pass the current date to apply your desired filter.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (