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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] incorrect use of date-time field

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] incorrect use of date-time field
 Login/Join
 
Platinum Member
posted
Hi,
When I run this:

TABLE FILE DATA2
PRINT PAT_ID HSP_PAT_ENC REALBEG
COMPUTE LASTBEG/HYYMDS = IF HSP_PAT_ENC EQ LAST HSP_PAT_ENC THEN LAST REALBEG ELSE REALBEG ;
BY HSP_PAT_ENC
BY HIGHEST REALBEG
ON TABLE HOLD AS DATA3
END

I get the following. REALBEG is in HYYMDS format.

0 ERROR AT OR NEAR LINE 156 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC36346) INCORRECT USE OF DATE-TIME FIELD OR CONSTANT
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: Kerry,


Windows version 768
 
Posts: 215 | Registered: March 16, 2006Report This Post
Virtuoso
posted Hide Post
I tried to duplicate your request using MSSQL, but was not successful.
What DBMS do you use?
In MSSQL the HYYMDS data format is unsupported and doing it in a define did not give me the error message.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
Can you post the master for DATA2 ?

Is it something to do with the LAST ?

Is it something to do with the data ?

Perhaps you could try simplyfing the COMPUTE. Try setting LASTBEG initially, then start adding the code back to see what make the code fail.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] incorrect use of date-time field

Copyright © 1996-2020 Information Builders