I need to determine if my incoming date is between to dates in my table.(these are all DateTime format) I tried this I got semantic error.
InDate >= Date1 and InDate <= Date2

What can I use to test these dates. I have gone the help and found nothing so far.

Assuming this is with FOCUS code, then:

WHERE InDate GE Date1 and InDate LE Date2

or

WHERE InDate FROM Date1 TO Date2

What are Date1 and Date 2, are they amper variables ?

Hi Brenda, DQC engine works using JAVA. Date comparisson can be done converting from dates to miliseconds, or to string with format yyyy-MM-dd.

Hope it helps.