 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] date result dosen't match with the field
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] date result dosen't match with the field Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] date result dosen't match with the field | Login/Join |
| Member |
Hi guys i am trying to run the following code but says Error: FOC282 RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD, Code: DEFINE FILE USER_HOLD -*TEST/I11 = IF LOGINS EQ 0 THEN 0 ELSE 1; D_DATE/DMY = HDATE(CERTIFICATIONDATE, 'YYMD'); I_MONTH/I2 = DPART(D_DATE, 'MM', 'I11'); S_MONTH/M = I_MONTH; A_MONTH/A4 = EDIT(I_MONTH); -* the error is at -*this line. I_YEAR/I4 = DPART(D_DATE, 'YEAR', 'I11'); S_YEAR/YY = I_YEAR; A_YEAR/A4 = EDIT(I_YEAR); A_YEAR_MONTH/A8 = A_YEAR|A_MONTH; ENDThis message has been edited. Last edited by: <Kathryn Henning>, 8008 | ||
|
| Expert |
1) What is the format of CERTIFICATIONDATE? 2) Please tell us what you're trying to do. You may be overdoing the code... Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Member |
Well the CERTIFICATIONDATE is in TIMESTAMP FORMAT Without TIMEZONE and i m trying to convert the date into month in alphanumeric format 8008 | |||
|
| Expert |
Shortest form that you could use is something like - D_DATE/A8 = DATECVT(HDATE(CERTIFICATIONDATE, 'YYMD'), 'YYMD', 'A8YYMD'); Remember the help pages for Functions (plus lots more) online - here T
| |||||||||
|
| Expert |
If you only want YYM in alpha format then just use - D_DATE/A6 = DATECVT(HDATE(CERTIFICATIONDATE, 'YYMD'), 'YYMD', 'A6YYM');
Just a little I think  T
| |||||||||
|
| Member |
Thanks for your solution However i need those value to use further to generate report. SO i'm not overdoing it! 8008 | |||
|
| Virtuoso |
First off, put your code between [code][/code] tags. Don't return an 'I11' if you're only going to use 2 or 4 decimals anyway. Better yet, return the value into the virtual field you're defining, that takes care of the field size automatically (I still think it's silly that FOCUS doesn't do that for us). That's probably why FOCUS thinks that I_MONTH won't fit in an A4 field; remember that that /I2 only specifies the display format, internally you made that field an I11. And why are you using DPART instead of HPART? You don't need that D_DATE field at all. Try this: -*D_DATE/DMY = HDATE(CERTIFICATIONDATE, 'YYMD'); I_MONTH/I2 = HPART(CERTIFICATIONDATE, 'MM', I_MONTH); S_MONTH/M = I_MONTH; A_MONTH/A4 = EDIT(I_MONTH); -* the error is at -*this line. I_YEAR/I4 = HPART(CERTIFICATIONDATE, 'YEAR', I_YEAR); S_YEAR/YY = I_YEAR; A_YEAR/A4 = EDIT(I_YEAR); A_YEAR_MONTH/A8 = A_YEAR|A_MONTH; WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux : | |||
|
| Member |
Thanks all of you. I'm helpful to think and try different approach finally i succefully run the part coz of ur support. Thanks again! 8008 | |||
|
| Expert |
Bearing in mind that your sample only appears to have some defines that are used to build a single result - A_YEAR_MONTH (with the exception of S_MONTH and S_YEAR). What I meant by overdoing it is, that in your sample, you convert CERTIFICATIONDATE into D_DATE and then convert that into I_MONTH and I_YEAR. You further convert I_MONTH into A_MONTH and I_YEAR into A_YEAR before combining both of those fields into A_YEAR_MONTH which is probably an extra 20 bytes per row of data pulled into the internal matrix in excess of the actual 8 bytes that is the ultimate result. If you multiply those 20 bytes by the number of rows returned from your request then your internal matrix is bigger than what it needs to be. Hopefully you understand what I meant?  T
| |||||||||
|
| Virtuoso |
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux : | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] date result dosen't match with the field
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] date result dosen't match with the fieldCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |