I want to create an outstanding check list. I need the check date to be on or before a particular date the user enters as a parameter. I also have an if statement that says if the cancel date is not missing, the cancel date should be on or before the same particular date the user enters as a parameter.

How do I set it up so the user only has to enter a single date that can be applied to both if/where statements?

This message has been edited. Last edited by: Kerry,

You can use the same amper variable in multiple places in a focexec. What you are trying to do doesn't seem to be a problem. You may have to reformat the incoming date parameter based on the formats of the dates you are comparing it to, but you should be able to do this easily.

Right...

TABLE FILE MYFILE
...
WHERE DB_DATE_FIELD1 GE &MY_DATE
WHERE DB_DATE_FIELD2 LE &MY_DATE
...
END