[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, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi What oconv are you using, and have you an example of how it is being displayed ? Rgds Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 07:30 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 help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2240 / Virus Database: 2641/5694 - Release Date: 03/21/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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.). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@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 help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Blairs Windows Limited is a company registered in Scotland. Company No: SC393935. Registered office: 9 Baker Street, Greenock, PA15 4TU. V.A.T. registration No: 108729111 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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.). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@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 help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Blairs Windows Limited is a company registered in Scotland. Company No: SC393935. Registered office: 9 Baker Street, Greenock, PA15 4TU. V.A.T. registration No: 108729111 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Which of course on UniVerse (for mixed case month) is OConv(Date(),DL) For Excel I find the ISO date format (-mm-dd) is the safest. Then it's just down to the Excel options as to how it formats that column. Brian -Original Message- From: u2-users-boun...@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: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
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 with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://Nebula-RnD.com/products/xlite.htm [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
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 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 with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
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 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 with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://Nebula-RnD.com/products/xlite.htm [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
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, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com 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 with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] DATE conversion problem
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 conversions. So you may want to look at your settings there. Be careful about using the UniObjects date conversion - every conversion is a call back to UniVerse. If you have a large array coming from UniVerse with internal dates and attempt to convert them within VB, it gets very slow. We wrote our own VB date conversion routines to get around this. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problem
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 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 conversions. So you may want to look at your settings there. Be careful about using the UniObjects date conversion - every conversion is a call back to UniVerse. If you have a large array coming from UniVerse with internal dates and attempt to convert them within VB, it gets very slow. We wrote our own VB date conversion routines to get around this. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. - This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problems
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 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 always appear as 10/01/2006 irrespective of the DATE.FORMAT command. So where you are using a date conversion , add 'E' to the end and it should work. Regards, Jonathan Smith IBM Certified Solutions Expert Advanced Support Engineer - U2 Advanced Technical Support IBM Data Management Solutions Support Phone 0800 773 771 Support mailto:[EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please delete it and notify the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] DATE conversion problems
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 always appear as 10/01/2006 irrespective of the DATE.FORMAT command. Sorry but that's not entirely correct. The 'E' code toggles from the current format. So if you are running in European date format already, it will show US format. For example: LIST BOOK_SALES SALE_DATE CONV D4/ SALE_DATE CONV D4/E 10 Jan 2006 PAGE 2 BOOK_SALES... Sale Date.. Sale Date.. 13533*37800*1 18/01/2005 01/18/2005 13605*50400*1 31/03/2005 03/31/2005 13715*44100*1 19/07/2005 07/19/2005 13716*62100*1 20/07/2005 07/20/2005 13555*40500*3 09/02/2005 02/09/2005 13494*38700*1 10/12/2004 12/10/2004 Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[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 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 10.1.4, UO ver 3.1.6.7084. Any help would be appreciated R, Sunny Sunny Matharoo Development Team Leader Tristar Worldwide Chauffeur Services Tel:+44 (0) 1895 432074 Fax:+44 (0) 1895 432098 E-mail: [EMAIL PROTECTED] www.tristarworldwide.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problem
You need to issue the server command: DATE.FORMAT This would normally be done by the UV.LOGIN paragraph in the UV account or by the LOGIN in the account, but UniObjects bypasses both of these. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 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 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 10.1.4, UO ver 3.1.6.7084. Any help would be appreciated R, Sunny Sunny Matharoo Development Team Leader Tristar Worldwide Chauffeur Services Tel: +44 (0) 1895 432074 Fax: +44 (0) 1895 432098 E-mail: [EMAIL PROTECTED] www.tristarworldwide.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problem
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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Date Conversion Codes
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., OCT. 13, 2005 oconv( 13801, DYMD[4'',2'',2] ) = 20051013 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) : iconv( 20051013,D4) = 13801 and iconv(051013,D) = 13801 and I think that: iconv( 20051013,D) = 13801 --mats cds From: Richard Lewis And did you know you can get that result without multiple conversions? Try: DYMD[4'',2'',2] instead of: DYMD[4,2,2]}MCN ___ From: [EMAIL PROTECTED] 0007: dwamdby[, ,,2, ] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes - iconv
-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) :
iconv( 20051013,D4) = 13801
and
iconv(051013,D) = 13801
and I think that:
iconv( 20051013,D) = 13801
though ISO8601 requires iconv formating : iconv('2005-10-13','dymd') :
at least when DATE.FORMAT is ON
--
Stu
**
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support
Centre (+61 3 9269 7555) immediately, who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer related viruses.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes - iconv
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 aren't ISO8601's hours, minutes and seconds back to front, too?
--
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/131 - Release Date: 12/10/05
Regards,
Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia
http://www.taloncs.com.au
Tel: +61 (0)411149636
Fax: +61 (0)260232119
If it ain't broke, fix it till it is!
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/131 - Release Date: 12/10/05
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[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) or simplified date formats (10-12-2005), but I haven't been able to figure out how to string them together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
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, 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) or simplified date formats (10-12-2005), but I haven't been able to figure out how to string them together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 ;:;14(DM);:;C, ;:;14(DY4);:;(MCT) 0009 L 0010 25 -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 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 together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
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 -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 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 together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
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 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 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 together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
OOPS... :-( Fat-fingered the day portion. Change (DM) to (DD) 0008 F;14(DWA);C, ;:;14(DMB);:C ;:;14(DD);:;C, ;:;14(DY4);:;(MCT) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donnie Jacobs Sent: Wednesday, October 12, 2005 3:06 PM To: u2-users@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 ;:;14(DM);:;C, ;:;14(DY4);:;(MCT) 0009 L 0010 25 -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 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 together. The UniVerse documentation has been less than helpful with this matter. I'd appreciate any suggestions. Regards, Rick __ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 Wednesday September 14 2005 DWAMADY[3,3,2,4] 15R WED SEP 14 2005 DWAMADY[3,3,2,4]}MCT 15R Wed Sep 14 2005 DWAMADY[3,3,2,4]}MCT 19R#3.,#4.#3,#5 Wed., Sep. 14, 2005 ^ /|\ | | The } is a value-mark. Did we know we could have multiple conversions, separated by value marks? Could probably tack an A or F conversion/correlative code in there, too. My favourite is to get CCYYMMDD format by date conversion, then Mask-Character-Numeric to strip out the delimiters: 01 D some date field, output as CCYYMMDD 02 nnn 03 DYMD[4,2,2]}MCN 04 05 8R Or in basic: CCMMYDD = OCONV( Idate, 'DYMD[4,2,2]':@VM:'MCN' ) ^ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
slick - i new about the multi conversions seperated by @VM but i didn't know you could pack the date conversions together like that -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Wednesday, October 12, 2005 06:38 PM To: u2-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}MCT 30L Wednesday September 14 2005 DWAMADY[3,3,2,4] 15R WED SEP 14 2005 DWAMADY[3,3,2,4]}MCT 15R Wed Sep 14 2005 DWAMADY[3,3,2,4]}MCT 19R#3.,#4.#3,#5 Wed., Sep. 14, 2005 ^ /|\ | | The } is a value-mark. Did we know we could have multiple conversions, separated by value marks? Could probably tack an A or F conversion/correlative code in there, too. My favourite is to get CCYYMMDD format by date conversion, then Mask-Character-Numeric to strip out the delimiters: 01 D some date field, output as CCYYMMDD 02 nnn 03 DYMD[4,2,2]}MCN 04 05 8R Or in basic: CCMMYDD = OCONV( Idate, 'DYMD[4,2,2]':@VM:'MCN' ) ^ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
--- 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-Character-Numeric to strip out the delimiters: 01 D some date field, output as CCYYMMDD 02 nnn 03 DYMD[4,2,2]}MCN 04 05 8R Or in basic: CCMMYDD = OCONV( Idate, 'DYMD[4,2,2]':@VM:'MCN' ) ^ --- And did you know you can get that result without multiple conversions? Try: DYMD[4'',2'',2] instead of: DYMD[4,2,2]}MCN Just for a little more jollies! Sincerely Best Regards, Richard Lewis Sr. Programmer/Analyst Nu Skin Enterprises ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
... 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 tried doing it via date conversion codes in dictionary field 7. I can get ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes
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( 13801, DYMD[4'',2'',2] ) = 20051013 And the last can swing both ways: iconv( 20051013, DYMD[4'',2'',2] ) = 13801 cds From: Richard Lewis And did you know you can get that result without multiple conversions? Try: DYMD[4'',2'',2] instead of: DYMD[4,2,2]}MCN ___ From: [EMAIL PROTECTED] 0007: dwamdby[, ,,2, ] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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] [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 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 the spaces in the date. Is there another date format conversion that we can use or we do we have to create another dictionary to remove these blanks ? - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Format
To be explicit, I think you'll have to create a dictionary item. I don't know how to do a date conversion with spaces removed using a single date conversion function/format. Something on my wish list... (UniData) - of course the second conversion could be in attribute 3. 001: V 002: DATE;OCONV(@,'D4MDY');OCONV(@,'MCN') 003: 004: Date 005: 8R 006: S Karjala [EMAIL PROTECTED] 06/10/2004 11:27:27 AM 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 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 the spaces in the date. Is there another date format conversion that we can use or we do we have to create another dictionary to remove these blanks ? - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Date Conversion Format
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 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
the spaces in the date.
Is there another date format conversion that we can use or
we do we have to create another dictionary to remove these blanks ?
-
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
This e-mail was scanned for viruses using BitDefender.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Format
Thanks, we'll see if Mvquery lets me do that. --- Dana Baron [EMAIL PROTECTED] wrote: Or CONVERT TO IN DATE.VAR (The first set of quotes has a blank, the second does not). Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [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] [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 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 the spaces in the date. Is there another date format conversion that we can use or we do we have to create another dictionary to remove these blanks ? - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
