Focal Point
DQC need help with date comparasion

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8007039816

April 12, 2012, 11:16 AM
Brenda Wilkerson
DQC need help with date comparasion
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.



WebFOCUS 7.7.03
Windows 7
April 12, 2012, 05:46 PM
Waz
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 ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 08, 2012, 03:29 AM
TommyKnocker
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.


DS 7.6.11
iSM 5.5, 5.6, 6.0.X
WXP, Ubuntu 10.04 LTS