385
I have a start date and end date field on a form.
I would like to create a view that only shows things that are not past the end date.
So basically today() is not after end date.
But I can't figure out how to get that?
Is that something I can do with fetch? If so what is the expression to use not Today()? CURDATE()? Etc.
Thanks,
Terry
Hi partner,
You could use calculate field to get the days between now and the end date and then use this as a filter condition to create a view.
Here are the steps.
1. Create a calculate filed (whole number).
2. Click the edit button to config the calculation rules.
We use the formula provided by Microsoft to calculate the days between today and end date.
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/define-calculated-fields
Then the number filed will store the days.
3.Create a new view.
Then you could set the view filter condition like if daffer>0 (which means) we haven't reached the end of the day yet today.
Hope it helps.
Best Regards,
Leo
Hi,
There is no out of box operator to return results greater than today but you can use "Next 'X' Years" operator and specify some high number like 99 years. This way you are telling crm to return records which are in next 99 years.
Hope this helps.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
