cancel
Showing results for 
Search instead for 
Did you mean: 

Add 'On or Before TODAY' when comparing date time in Advanced Find

Author Name: JEAN LEFRANCOIS

Add a date fonction which would enable filter in views and advanced finds to manage a date from or to the current date, without having to add the current date every time.

Status: Under Review
Comments
Level: Powered On
Status changed to: Under Review
 
Level: Powered On
In Advanced Find you can use criteria such as "in the last X days" or "in the next X weeks", and use OR grouping. It would be nice to have the convenience of this in a filter, but Advanced Find is a pretty quick way of getting to this.
Level: Powered On
Hi, As mentioned by Adam in a previous comment, you can do date filters in Advanced Find for Last X Days and Next X Days which will filter X Days to Today, or X days from Today() without needing to put in the date today. I'm curious to know where these existing filters are not working for you. Could you provide an example? Thanks, Satya Puniani Program Manager Dynamics CRM
Level: Powered On
thanks, hopefully in the future have a real Today, for Workflow and Queries, thanks
Level: Powered On
What about if you want to show all 'overdue' items in a dashboard view? I can't seem to find any way to do this, as all the 'relative' comparisons include today in the filter. For example if I have a 'next contact date' attribute, and I want a view to show me all the records with 'next contact date' that are overdue (i.e. BEFORE today) I can't seem to figure out how to do that without a plugin...and that seems to be pretty basic CRM-type functionality. The workaround is to write a report, but that's less than ideal.
Level: Powered On
Ken, Your suggestion is under consideration already. Please add your vote to it at this link: http://connect.microsoft.com/dynamicssuggestions/feedback/details/685333/add-on-or-before-today-when... ~Satya Program Manager, Dynamics CRM This posting is provided "as is" with no warranties, and confers no rights.Updated by Connect Synchronizer; see History tab for changed fields.
Level: Powered On

Should close this feedback.  Since CRM 2016 Advanced Find will allow for this.  Check this blog on how to setup out of the box Advanced Find to find records before today

https://mscrmonline.wordpress.com/2018/02/26/advanced-find-before-today-or-older-than-today/