Re: Need help Datefield Retrieval like this mmddyyyy -Reply

[Mark Kraft <kraftm@GUNET.GEORGETOWN.EDU>]

Just a final thought....

there are several ways to do this...
to_char(yadda yadda)
move the variable with an edit mask
do format-datetime (my preference in PeopleSoft since it is 100%
database independant)..just make sure you make the $ddelimiter null to
remove the '/' or '-'

it primarily depends on the database and what ever else you are working
on.  If you not on Peoplesoft, the last one won't work and the to_char is
the best way.  If you are using PeopleSoft, the last one is the best way
by far, since it is delivered in the Datetime.SQC

There is my 2 1/2 cents.

Mark Kraft
kraftm@gunet.georgetown.edu