Re: QUERY/400: Current system date in CYYMMDD format

That works for me....

Thanks!


Peter Vidal 
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"Do something. If it doesn't work, do something else. No idea is too 
crazy."
Jim Hightower, The New York Times, March 9, 1986




"Steve McKay" <steve.mckay@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/26/2007 11:22 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Re: QUERY/400: Current system date in CYYMMDD format






ISOTODAY - technically, I guess it's not an ISO date but you get the idea.

Steve

"Steve McKay" <steve.mckay@xxxxxxxxxxx> wrote in message 
news:mailman.1812.1174922285.9222.midrange-l@xxxxxxxxxxxxxxx

Quickly -

Field                Expression
TODAY           char(current(date))

ISOTODAY    '20' || substr(Today,7,2) ||
                        substr(Today, 1, 2) ||
                        substr(Today, 4, 2)

HTH,

Steve

"Peter Vidal" <Peter_Vidal@xxxxxxxx> wrote in message 
news:mailman.1806.1174920803.9222.midrange-l@xxxxxxxxxxxxxxx

Hi list:

How can I do this format?

TIA,


Peter Vidal
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"Courage is the strength or choice to begin a change. Determination is 
the
persistence to continue in that change."
Anonymous