[U2] Date conversion..

2013-03-22 Thread Sathya
Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V.

Re: [U2] Date conversion..

2013-03-22 Thread Symeon Breen
@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA

Re: [U2] Date conversion..

2013-03-22 Thread Jonathan Leckie
...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 7:30 am To: u2-users@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please

Re: [U2] Date conversion..

2013-03-22 Thread Martin Phillips
Of Jonathan Leckie Sent: 22 March 2013 10:15 To: 'U2 Users List' Subject: Re: [U2] Date conversion.. I always use : OCONV(DATE(),'DDMY,A,Z4') In data that is going to a spreadsheet, it means Excel knows it is a date and stops Excel changing the format to American (we are based in the U.K

Re: [U2] Date conversion..

2013-03-22 Thread Mecki Foerthmann
I use OCONV(DATE(),'D') and that works just fine because it displays today as 22 Mar 2013. On 22/03/2013 11:19, Martin Phillips wrote: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Date conversion..

2013-03-22 Thread Brian Leach
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 22 March 2013 14:11 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Date conversion.. I use OCONV(DATE(),'D') and that works just fine because it displays today as 22 Mar 2013. On 22/03/2013 11:19, Martin Phillips wrote

Re: [U2] Date conversion..

2013-03-22 Thread Tony Gravagno
From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't

Re: [U2] Date conversion..

2013-03-22 Thread Israel, John R.
I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: From: Sathya Hi experts.. I have one

Re: [U2] Date conversion..

2013-03-22 Thread Charlie Noah
Hi Tony, It looks like development on NebulaXLite only goes to 2009. Does it work with Jbase 3.4 on XP (32 bit)? I looked on your site and in the FAQ, but it didn't really tell me. Thanks, Charlie On 03-22-2013 11:15 AM, Tony Gravagno wrote: From: Sathya Hi experts.. I have one problem in

Re: [U2] Date conversion..

2013-03-22 Thread Charlie Noah
Also with less problems with double quotes. Charlie On 03-22-2013 11:26 AM, Israel, John R. wrote: I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22,

RE: [U2] DATE conversion problem

2006-01-11 Thread u2ug
REPOSTED FOR NONMEMBER: Kryka, Richard [EMAIL PROTECTED] Snip I have a specific problem whereby any formatting I do using UniObjects always gives me the date in US format even though all PC settings say UK settings. My Response I think that UniObjects goes back to the UniVerse system for date

RE: [U2] DATE conversion problem

2006-01-11 Thread asvin . dattani
Hi, Universe defaults to American style date format. To get round this, I explicitly set european date format when I create the session object: sess.command(DATE.FORMAT ON) where sess is the session object. hth, cheers, asvin [EMAIL PROTECTED] wrote on 11/01/2006 11:08:40: REPOSTED FOR

RE: [U2] DATE conversion problems

2006-01-10 Thread Jonathan D Smith
Hi, You are correct by default UniVerse will use the American Format unless overridden by DATE.FORMAT in the LOGIN or UV.LOGIN paragraph. However, a little used method (which is documented, but ignored by most) is to force the Date Format in the conversion you use. For example if you use the

RE: RE: [U2] DATE conversion problems

2006-01-10 Thread brian
little used method (which is documented, but ignored by most) is to force the Date Format in the conversion you use. For example if you use the conversion 'D4/' then today would appear as 01/10/2006 or 10/01/2006 depending upon DATE.FORMAT. However if you use the conversion 'D4/E' it will

[U2] DATE conversion problem

2006-01-09 Thread Sunny Matharoo
Hi I have a specific problem whereby any formatting I do using UniObjects always gives me the date in US format even though all PC settings say UK settings. I was wondering is there something that we need to set for UO to display date in UK format from within the program. We are using UV

RE: [U2] DATE conversion problem

2006-01-09 Thread Brian Leach
Of Sunny Matharoo Sent: 09 January 2006 17:48 To: u2-users@listserver.u2ug.org Subject: [U2] DATE conversion problem Hi I have a specific problem whereby any formatting I do using UniObjects always gives me the date in US format even though all PC settings say UK settings. I

RE: [U2] DATE conversion problem

2006-01-09 Thread Ray Wurlod
You can change your system default date format in the msg.text file (LOC0020). From UniObjects you can execute a DATE.FORMAT command via a Command object, but this applies only to the Session object from which the Command object was instantiated. --- u2-users mailing list

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(

RE: [U2] Date Conversion Format

2004-06-10 Thread Kevin King
Could you double-convert? Convert via D2/ or D4/ to start, then MCN to remove the symbols. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Thursday, June 10, 2004 8:21 AM To: U2 USERS Subject: [U2] Date Conversion Format I am using looking

RE: [U2] Date Conversion Format

2004-06-10 Thread Karjala Koponen
Sent: Thursday, June 10, 2004 8:21 AM To: U2 USERS Subject: [U2] Date Conversion Format I am using looking for a date format conversion to use. We are using the format DDMMY which formats the date to 02 10 1970. We are creating an MVQUERY extract and the customer would prefer to eliminate

Re: [U2] Date Conversion Format

2004-06-10 Thread Karjala Koponen
Ed, Wonderful! Another technique I had no idea existed. Karjala [EMAIL PROTECTED] 06/10/2004 11:17:14 AM D4A {value-mark} MCN Ed Weissman - Original Message - From: Dave S [EMAIL PROTECTED] To: U2 USERS [EMAIL PROTECTED] Sent: Thursday, June 10, 2004 10:20 AM Subject: [U2] Date

RE: [U2] Date Conversion Format

2004-06-10 Thread Dave S
] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Thursday, June 10, 2004 11:27 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Date Conversion Format Could you double-convert? Convert via D2/ or D4/ to start, then MCN to remove the symbols. -Original Message- From: [EMAIL PROTECTED