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
how to compare Date with decimal value
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: