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

PanJ

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

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

mohana_cse06

what is the date format in your machine?

zohaibu95@hotmail.com

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

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

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

PanJ

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

PanJ

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

Please change it to MM/DD/YY and try

mohana_cse06

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

PanJ

thanks again
l love this site!

zohaibu95@hotmail.com

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