Hi,
I want to compare dates in SAP IS, if 1 date is greater than the other, but when I do the test it doesn't compare the full date format (e.g DD.MM.YYYY) but it'll maybe compare DD only and ignores MM and YYYY or MM and igonres DD and YYYY.
Example 1: I want to return TRUE if DATE1 is less than DATE2 where DATE1 = 31.10.2011 and DATE2 = 31.10.2012. In this case it should consider the year as well but it only looks at the DD and MM and returns TRUE for equality of DD and MM.
Example 2: I want to return TRUE if DATE1 is less than DATE2 where DATE1 = 31.10.2012 and DATE2 = 01.11.2013. In this case it returns TRUE as it sees DD of DATE1 being greater than DD of DATE2.
These examples shoud return FALSE looking at the entire date format and not only bits and pieces...
Please help