Filtering a form to show data for Date()+1

[paulmcdonnell]

Is this fundamentally wrong... I have a form which is basically a diary. Based on a table of entries. I have controls to show all appointments, today's, tomorrow's, yesterday's etc...

My filter works fine for if control is clicked filter is Date(), but how do I get the filter to display tomorrows when date()+1 just lists blank (and there's loads of data there)?

Cheers

paul

 

[mboe]

The query doesn't know what +1 stands for, is it day weeks months. Use dateadd("d",1,date())