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
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.
iSM 5.5, 5.6, 6.0.X
WXP, Ubuntu 10.04 LTS
|Powered by Social Strata|