Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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    Search    Search Results
Page 1 2 3 4 ... 28
Go
Search
Tools
Search Results: (545 matches) New Search Login/Join 

Discussion Topic  RE: [CASE-CLOSED]Testing dates from ORACLE (in WebFOCUS/FOCUS Forum on Focal Point ) by Tom Flynn
Lookup the HDATE function...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Change HYYMDm to YYMD (in WebFOCUS/FOCUS Forum on Focal Point ) by jgelona
HDATE function in WebFOCUS...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: how to convert a long (10) datetime field to short (8) (in WebFOCUS/FOCUS Forum on Focal Point ) by Darin Lee
Check out the HDATE function in Help....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: how to convert a long (10) datetime field to short (8) (in WebFOCUS/FOCUS Forum on Focal Point ) by mike
HDATE converts datetime to DATE. I'll lose the time portion....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Trim Field Length (in WebFOCUS/FOCUS Forum on Focal Point ) by Prarie
NEWDATE/YYMD = HDATE(END_DATE_TIME, 'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] DATECVT error (in WebFOCUS/FOCUS Forum on Focal Point ) by Developer Phila
Thank you. Using HDATE worked....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]DATE (in WebFOCUS/FOCUS Forum on Focal Point ) by Shakila Subhan
quote:APPROVAL_DATEAPPROVAL_DATE1/YYMD = HDATE(APPROVAL_DATE,'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]DATE (in WebFOCUS/FOCUS Forum on Focal Point ) by QuickLearner
quote:APPROVAL_DATE1/YYMD = HDATE(APPROVAL_DATE,'YYMD');thank you...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]DATE (in WebFOCUS/FOCUS Forum on Focal Point ) by QuickLearner
quote:APPROVAL_DATE1/YYMD = HDATE(APPROVAL_DATE,'YYMD');Is this suppose to be 1 line: asAPPROVAL_DATE1/YYMD = HDATE(APPROVAL_DATE,'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Date Output in COMT Format (in WebFOCUS/FOCUS Forum on Focal Point ) by PBrightwell
try COMPUTE CDATE/YYMD=HDATE(CALENDARDATE,'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: DATE FORMAT (in WebFOCUS/FOCUS Forum on Focal Point ) by Prarie
Try this in a define. DDATE/I6YMD = HDATE(CHECK_DATE, 'YMD')...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: (Solved) How to compare 2 days effectively (without pulling the whole table from DB)? (in WebFOCUS/FOCUS Forum on Focal Point ) by Prarie
Then change the format of the dates.DDATE/YYMD = HDATE(DATE1, 'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Convert Date To AlphaNumeric / Convert Time To AlphaNumeric / Date Time to Date-Time (in WebFOCUS/FOCUS Forum on Focal Point ) by Prarie
Do some research on HDATE and HTIME. See if that helps...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: ***CLOSED Easiest way to Convert a Date (in WebFOCUS/FOCUS Forum on Focal Point ) by CoolGuy
http://infocenter.informationb...rce%2Fdatetime14.htmUse HDATE()...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Extracting Year only from a date field (in WebFOCUS/FOCUS Forum on Focal Point ) by atturhari
You need to use HDATE,COMPUTE YOUR_DATE/YYMD =HDATE (PLANNED_END,'YYMD');COMPUTE YEAR_ONLY/YY = YOUR_DATE;HariWF-769...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Using a define to reformat a field (in WebFOCUS/FOCUS Forum on Focal Point ) by reFOCUSing
Try using HDATE or HPART. field2/SDfmt = HDATE (DTfield, format); field2/Afmt = HPART (DTfield, 'unit', format); I like HDATE the best because it needs less input values....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Date-Time field display (in WebFOCUS/FOCUS Forum on Focal Point ) by Prarie
Try ThisDDATE/YYMD = HDATE(WKEND_DATE, 'YYMD');NDATE/MtrDYY = DDATE;...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: field timestamp in table DB2 (in WebFOCUS/FOCUS Forum on Focal Point ) by FrankDutch
You can define a new field with the functionDATEFIELD/YYMD=HDATE(TIMESTAMP, 'YYMD')...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Date time conversion (in WebFOCUS/FOCUS Forum on Focal Point ) by Leah
I've not worked with that format, but in the master if it is a usage USAGE=HYYMDS, would HDATE work?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Comparing HYYMDS fields (in WebFOCUS/FOCUS Forum on Focal Point ) by Spence
try reformatting pay_date hyymds to yymd.PAY_DATE1/YYMD = HDATE(PAY_DATE, 'YYMD');...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 ... 28 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders