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.
@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
...@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
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
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
[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
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
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
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
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,
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
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
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
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
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
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
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
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.,
-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) :
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
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
, 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
-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
-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
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
@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
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]
@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
--- 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
...
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
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(
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
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
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
]
[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
35 matches
Mail list logo