Page 1 of 1

how to compare Date with decimal value

Posted: Thu Jun 18, 2009 2:27 am
by deesh
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

Posted: Thu Jun 18, 2009 3:52 am
by ArndW
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.

Posted: Thu Jun 18, 2009 4:30 pm
by ray.wurlod
Moderator: please move to parallel forum