Dynamics NAV

Showing posts with label Wrong Date filters. Show all posts
Showing posts with label Wrong Date filters. Show all posts

Wednesday, 14 January 2015

One or more filters are not valid and will be ignored Message in NAVISION RTC

Today I tried to run (Preview) a Report with Date Filter and I got below confirmation message


Microsoft Dynamics NAV
---------------------------
One or more filters are not valid and will be ignored. Do you want to continue?
---------------------------
No   Yes
---------------------------




























Then I found that this is because of Wrong date format entered in Birth Date filter.
Date format in My system is set to DDMMYY and I entered as MMDDYY.

But this behavior is different in Classic Client (NAV2009R2).

I tried to enter same MMDDYY format in classic client Birth Date filed.

But It gives an error message as shown below
---------------------------
Microsoft Dynamics NAV Classic
---------------------------
'013150' is not a valid date.
---------------------------
OK 
---------------------------