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. W

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

Re: [U2] Date Conversion Codes

2005-10-12 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',

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,

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'

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 CCYYMMD

RE: [U2] Date Conversion Codes

2005-10-12 Thread gerry-u2ug
users@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}

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 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(

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: [E

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 h

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 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,