Question
Date Filter is not working
Hi All,
Can you please help to resolve the below issue?
I have implemented a worklist which consist of column which indicates the closure date of particular case, the requirement says the date field should show the closure date of last 90 days.
As a part of solution to this problem I have included a condition in report definition and as the Column contains closure date I selected the filter condition as Last 90 Days (.ClosureDate <= Last 90 Days) but somehow this configuration is not working and also column filtering is not working.
Note : The .ClosureDate property type is Date
Any solution around this ?
Thanks.
Yogesh.
***Edited by Moderator: Lochan to update platform capability tags***
Hi YogeshSarsambe,
According to our documentation for the evaluation of symbolic dates (which can be found here). Performing a "LESS THAN OR EQUAL TO" condition will only use the ending date of the "last 90 days" symbol.
It looks like the "IS EQUAL TO" condition may return what you are expecting.
I hope this helps!