The filter is not valid for the Period Start field on the Date table.

PanJ · 2017-01-20

Hello,

I got an error after hit 'F7' button.

I cleared the filter but an error still come out. Then l tried to find other solution and there is a hotfix https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb%3bEN-US%3b2934571. But I concern if I have to install it on the system.

Is there anything l can fix besides installing hotfix?

Thank you for your help.

mohana_cse06 · 2017-01-20

Was the screenshot old format or new format?
it should be MM/DD/YY..

mohana_cse06 · 2017-01-20

what is the date format in your machine?

zohaibu95@hotmail.com · 2017-01-20

Make sure your date which you have passed in the SETFILTER function must meet with your REGION DATE FORMAT (which the clocks show you).

If you want to make it generic you can use DMY2DATE function. This function will automatically convert the date into your DATE REGION format.

Date := DMY2DATE(Day,Month,Year);

Let me know if you need any help.

PanJ · 2017-01-20

l checked on Region Date Format and it was different from other users' computer which it's working and changed it, still got an error.

I will check on SETFILTER.

thank you guys

mohana_cse06 · 2017-01-20

Was the screenshot old format or new format?
it should be MM/DD/YY..

PanJ · 2017-01-20

in screenshot was the new format.
other users don't have this issue by the way

PanJ · 2017-01-20

mohana_cse06

I changed Date Format follow by what you told me, it's working now!

Thank you all, l appreciate your help

mohana_cse06 · 2017-01-20

Please change it to MM/DD/YY and try

mohana_cse06 · 2017-01-20

didn't see your last response. good to hear.

PanJ · 2017-01-20

thanks again
l love this site!

zohaibu95@hotmail.com · 2017-01-20

You are welcome @PanJ . Please accept / like our answers

thank you.

The filter is not valid for the Period Start field on the Date table.

Best Answer

Answers

Categories