how to compare Date with decimal value

deesh · Post by **deesh** » Thu Jun 18, 2009 2:27 am

Hi friends,

How to compare the Date,Here the input Data type is Decimal and i need to compare the current date with the input decimal value, Please help me in this one.

CCVADF and CCVADT are the DECIMAL (8)

ccvadf<=TODAY and ccvadt>=TODAY

ArndW · Post by **ArndW** » Thu Jun 18, 2009 3:52 am

What method was used to convert the date to a decimal value? Is the date stored as a YYYYMMDD or a YYYYDDD or a Julian date? Without knowing that, a conversion or comparison is not possible.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 18, 2009 4:30 pm

Moderator: please move to parallel forum