| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 3681.1 | | AIMTEC::ZANIEWSKI_D | Why would CSC specialists need training? | Mon Dec 20 1993 13:10 | 3 |
| If the source format is dd-mmm-yyyy use format key #8.
Dave Zaniewski
|
| 3681.2 | still a problem | GIDDAY::BURT | Scythe my dandelions down, sport | Mon Dec 20 1993 23:41 | 25 |
| Hi Dave,
re <<< Note 3681.1 by AIMTEC::ZANIEWSKI_D
> If the source format is dd-mmm-yyyy use format key #8.
Using format key #8 doesn't work.
"Source date is in an incorrect format" (ie not NBS)
I thought it might be possible to try using key #7, to convert to NBS,
then key #8 to convert back out of NBS, would work, but it still leaves the
date in dd/mm/yyyy format.
I suspect that the problem relates back to the fact that it is the British kit
(well, partially).
The object is to get the date format from dd/mm/yyyy to mm/dd/yyyy.
Any other ideas?
Thanks & regards,
Chele B
|
| 3681.3 | Temporarily changing the profile ... | IOSG::MAURICE | I left my heart in Alcatraz | Tue Dec 21 1993 08:40 | 17 |
| Here's one method that would work, but not be quick - so would be OK if
used infrequently. Assuming the user's profile setting for date format
starts at "2" which is UK format, the script below temporarily changes
it to US format, and then restores it.
get #gb = "25/12/93"
date_convert #nbs, #gb, 7
write change profil user=oa$user, date$format=1
oa$ini_glob
date_convert #us, #nbs, 8
write change profil user=oa$user, date$format=2
oa$ini_glob
get oa$display = "Converted date = " #us
Cheers
Stuart
|
| 3681.4 | Alternatively... | IOSG::MARCHANT | I'd sink therefore I swam | Tue Dec 21 1993 10:41 | 7 |
| If you want a quick 'n dirty method, how about:
date_convert #nbs, #GB_time, 7
get #US_time = #nbs:2:4 "/" #nbs:2:6 "/" #nbs:2:2
Cheers,
Paul.
|
| 3681.5 | | GIDDAY::BURT | Scythe my dandelions down, sport | Tue Jan 04 1994 02:46 | 9 |
| Hello and Greetings,
Thankyou very much - the .3 method is what the customer decided upon using,
and works to his satisfaction.
Is it likely that the date_convert will ever be a little friendlier to those
of us in "forn parts"?
Chele
|