I have a small DB tracking some tools. In one of my queries, I have one field with an expr. that gets "today's" date, then in the next field, gives me the date a specific interval from today. This then is used with a report to print labels for the tools. This works.
Now I need to add a similar query that will do almost the same thing, but instead of getting today's date, it asks for a date, then add to that. This is so when needed I can reprint a label if needed. I even made a copy of the first query, then just changed the expr to ask for the date I want there. The query does ask for the date to use, the problem is that rather then giving me the new date , it shows #ERROR.
What did I miss?