DAY_DIFFERENCE always shows positive numbers!

If you think that something doesn't work in Aware IM post your message here
Post Reply
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

DAY_DIFFERENCE always shows positive numbers!

Post by BLOMASKY »

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
softserv
Posts: 93
Joined: Mon Aug 01, 2016 12:52 am
Location: Jaipur, India
Contact:

Re: DAY_DIFFERENCE always shows positive numbers!

Post by softserv »

Yes, it is working as expected. It just shows the count of day difference, no - or +.
Team SoftServ

V8.3 2628 |V8.2 2574 |V8.1 2475 | V8.0 2372 | V7.1 2240 | V6.0 2042 | V5.9 1894
MS SQL Server | MySQL
AWS | Azure | Google Cloud

Image
SoftServ - AwareIM
Post Reply