[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Working with assigned dates.



Working with dates:

This is confusing. The following yields "ONE DATE IS GREATER".  I am getting a 
literal string comparison rather than a date comparison. Can someone explain 
why and how I can correct the code to perform a date comparison?

            LET $ONE_DT = STRTODATE('01-JAN-2002')
            LET $TWO_DT = STRTODATE('01-FEB-2002')
            IF $ONE_DT > $TWO_DT
               SHOW 'ONE DATE IS GREATER'
            ELSE
               SHOW 'TWO DATE IS GREATER'
            END-IF

-Ken


Ken Boettger
boettgek@cwu.edu
http://www.cwu.edu/~boettgek
x2944