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

RE: [U2] Date Conversion Codes

2005-10-12 Thread Bill_H
A Pick-style solution would be: TEST 001 S 002 3 003 Long Date 004 005 006 007 A3(DWA):', ':3(DMA)(T1,3):' ':3(DD):', ':3(DY) 008 009 R 010 23 Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ward Sent: Wednesday,

RE: [U2] Date Conversion Codes

2005-10-12 Thread Donnie Jacobs
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 ;:;14(DM);:;C, ;:;14(DY4);:;(MCT) 0009 L 0010 25

RE: [U2] Date Conversion Codes

2005-10-12 Thread Rick Ward
Thank you, Bill and Donnie. That was exactly what I was looking for. --- Bill_H [EMAIL PROTECTED] wrote: A Pick-style solution would be: TEST 001 S 002 3 003 Long Date 004 005 006 007 A3(DWA):', ':3(DMA)(T1,3):' ':3(DD):', ':3(DY) 008 009 R 010 23 Hope this helps. Bill

RE: [U2] Date Conversion Codes

2005-10-12 Thread gerry-u2ug
I'm not sure of anyway to do this in one clean step. I think you need to set up an I-DESC something like this : 0001: I 0002: DATE.FIELD;OCONV(@1,DWAL[3]):, :OCONV(@1,DMAL[3]): :OCONV(@1,DD[2]):, :OCONV(@1,DY[4]) 0003: 0004: 0005: 17L 0006: S -Original Message- From: [EMAIL

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(