I am facing some strange issue.When ever I am adding the date field in power filter(project or idea), evaluation is working fine but when I click on save and return I am getting System Error.I am facing this issue only in Production not in other environments.Did anyone faced the similar issue, if Yes do you have any solutions for me. Thanks in advance
Project Power Filter :project.schedule_start == date("2014-07-01T00:00:00") resulted in error.
What is the error in the logs ?
project.schedule_start == date("2014-06-01T00:00:00")
works for me in v13.3 Sandbox. Don't see a difference in the format.
Restart browser and depending on the error in the log maybe also the app service.
Thanks NJ & Urmas. Unfortunately it ended up being a defect in clarity which does not have fix at this moment, and workaround is to add date field into normal filter of list page rather than power filter.
Strangely it happens only for few cases not for all and we are one of them
CLRT-67499: which indicates if adding date type field into power filer,Clarity sometimes throws out system error in GUI as well as "ORA-01861:literal does not match format string" error in log.