20 pts.
0
Q:
Find # days between 2 dates in Query 400
How do I find the # of days between 2 dates. I'm trying to do this in AS/400 Query 400.
I'm looking to do this in the Results area where you do calculations. Can anyone help??? Thanks!!!!!
ASKED: May 24 2008  4:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
23625 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button

Hi,

You should be able to do this using the DAYS function :-

DAYS(Enddate) - DAYS(Startdate)

Regards,

Martin Gilbert.
Last Answered: May 27 2008  3:53 PM GMT by Gilly400   23625 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Pherrick   20 pts.  |   May 24 2008  4:11PM GMT

I’m looking to find the # of days between 2 dates in the AS/400 Query 400. I’m guessing it can be done in the results section of the query (where calculations are done). Any ideas????? Thanks!

 

Alessandro.panzetta   9615 pts.  |   May 26 2008  9:25AM GMT

Hello Pherrik,
I’m not really familiar with AS400 but I suppose that a DateDiff command should exist, try and search in the manuals.

 

Gilly400   23625 pts.  |   May 26 2008  10:17AM GMT

Hi,

You should be able to do this using the DAYS function :-

DAYS(Enddate) - DAYS(Startdate)

Regards,

Martin Gilbert.

 
0