AS/400 Query - Current date -1
Home > IT Answers > AS/400 > AS/400 Query - Current date -1
Soren
5 pts.
0
Q:
AS/400 Query - Current date -1
AS/400 Query, AS/400 queries, AS/400 date format
Is there a quick and easy way to calculate yesterdays date by using "Define result fields"
ASKED: Apr 1 2009  8:35 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Gilly400
23625 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
Hi,

This should do the trick - define a result field as :-

CURRENT(DATE) - 1 DAYS

Regards,

Martin Gilbert.

Hi Martin,

I need some brief example (coding) for the CURRENT(DATE).

Regards
SS

Hi,

Here's a copy from the screen :-


 Field       Expression                         Column Heading        Len   Dec
 YESTERDAY   CURRENT(DATE) - 1 DAYS


Can't make it any simpler than this.

Regards,

Martin Gilbert.
Last Answered: Apr 2 2009  9:21 AM GMT by Gilly400   23625 pts.
Latest Contributors: Ssaran   205 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0