Re: [U2] Date Conversion Codes

2005-10-13 Thread Mats Carlid
Stevenson, Charles wrote: No, I did not know these tricks! Thank-you, Richard Stuart. oconv( 13801, DWAMADY[', ',' ',2', ',4] ) = THURSDAY, OCTOBER 13, 2005 oconv( 13801, DWAMADYL[', ',' ',2', ',4] )= Thursday, October 13, 2005 oconv( 13801, DWAMADY[3'., ',3'. ',2', ',4] ) = THU.,

RE: [U2] Date Conversion Codes - iconv

2005-10-13 Thread Stuart . Boydell
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid [EMAIL PROTECTED] And the last can swing both ways: iconv( 20051013, DYMD[4'',2'',2] ) = 13801 The last conversion is also kinda default (at least in uv) :

RE: [U2] Date Conversion Codes - iconv

2005-10-13 Thread Bruce Nichol
Goo'day, At 16:58 13/10/05 +1000, you wrote: -Original Message- From: [EMAIL PROTECTED] though ISO8601 requires iconv formating : iconv('2005-10-13','dymd') : at least when DATE.FORMAT is ON Ah!Somebody else been in the review compliant bucket this week. Why

[U2] Date Conversion Codes

2005-10-12 Thread Rick Ward
I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've tried doing it via date conversion codes in dictionary field 7. I can get individual elements (like Wednesday) or simplified date formats (10-12-2005), but I haven't been able to figure out how to string them

RE: [U2] Date Conversion Codes

2005-10-12 Thread Bill_H
, October 12, 2005 11:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Date Conversion Codes I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've tried doing it via date conversion codes in dictionary field 7. I can get individual elements (like Wednesday

RE: [U2] Date Conversion Codes

2005-10-12 Thread Donnie Jacobs
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ward Sent: Wednesday, October 12, 2005 1:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Date Conversion Codes I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've

RE: [U2] Date Conversion Codes

2005-10-12 Thread Rick Ward
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ward Sent: Wednesday, October 12, 2005 11:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Date Conversion Codes I'm trying to output a nicely formatted date (eg, Wednesday, Oct

RE: [U2] Date Conversion Codes

2005-10-12 Thread gerry-u2ug
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Ward Sent: Wednesday, October 12, 2005 02:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Date Conversion Codes I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've tried doing it via date conversion codes

RE: [U2] Date Conversion Codes

2005-10-12 Thread Donnie Jacobs
@listserver.u2ug.org Subject: RE: [U2] Date Conversion Codes Try something like this. Works on UV10.1.12 14 is the attribute number where the date field is stored. You would need to adjust as appropriate. CT DICT DEBTOR DLJ DLJ 0001 A 0002 14 0003 0004 0005 0006 0007 0008 F;14(DWA);C, ;:;14(DMB);:C

RE: [U2] Date Conversion Codes

2005-10-12 Thread Stevenson, Charles
And just for jollies here are some others that are sorta like what you want: DICT 3. DICT 5... Result. DWAMADY 30L WEDNESDAY SEPTEMBER 14 2005 DWAMADY}MCT 30L Wednesday September 14 2005 DWAMADY[3,3,2,4]

RE: [U2] Date Conversion Codes

2005-10-12 Thread gerry-u2ug
@listserver.u2ug.org Subject: RE: [U2] Date Conversion Codes And just for jollies here are some others that are sorta like what you want: DICT 3. DICT 5... Result. DWAMADY 30L WEDNESDAY SEPTEMBER 14 2005 DWAMADY}MCT 30L

RE: [U2] Date Conversion Codes

2005-10-12 Thread rbl000
--- On Wed 10/12, Stevenson, Charles [EMAIL PROTECTED] wrote: From: Stevenson, Charles [mailto: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: Wed, 12 Oct 2005 18:38:12 -0400 Subject: RE: [U2] Date Conversion Codes My favourite is to get CCYYMMDD format by date conversion, then Mask

RE: [U2] Date Conversion Codes

2005-10-12 Thread Stuart . Boydell
... 0007: dwambyl[, ,,2, ] ... Also, see Ray Wurlords article: http://www.pickwiki.com/cgi-bin/wiki.pl?Date_Conversion_With_ OCONV -Original Message- From: Rick Ward I'm trying to output a nicely formatted date (eg, Wednesday, Oct 12, 2005), and I've

RE: [U2] Date Conversion Codes

2005-10-12 Thread Stevenson, Charles
No, I did not know these tricks! Thank-you, Richard Stuart. oconv( 13801, DWAMADY[', ',' ',2', ',4] ) = THURSDAY, OCTOBER 13, 2005 oconv( 13801, DWAMADYL[', ',' ',2', ',4] )= Thursday, October 13, 2005 oconv( 13801, DWAMADY[3'., ',3'. ',2', ',4] ) = THU., OCT. 13, 2005 oconv(