Showing posts with label Wrong Date Format in Filter. Show all posts
Showing posts with label Wrong Date Format in Filter. Show all posts

Saturday, 23 February 2013

One or more filters are not valid and will be ignored Message in NAV 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.

It immediately shown error message

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
'013150' is not a valid date.

---------------------------
OK
---------------------------