Is this the way it is supposed to work?
DISPLAY MESSAGE DAY_DIFFERENCE(AS_DATE('01/01/2017', 'MM/dd/yyyy'), AS_DATE('02/01/2017', 'MM/dd/yyyy'))
DISPLAY MESSAGE DAY_DIFFERENCE(AS_DATE('02/01/2017', 'MM/dd/yyyy'), AS_DATE('01/01/2017', 'MM/dd/yyyy'))
Both of these display 31.
Bruce
DAY_DIFFERENCE always shows positive numbers!
Re: DAY_DIFFERENCE always shows positive numbers!
Yes, it is working as expected. It just shows the count of day difference, no - or +.