So I am defining a new synonym to use with infoassist. I want the usage of the date fields to be more user friendly than the default format in WEBFOCUS.
The settings I have set for the date time field is
When I go to create a test report i get the following error.
(FOC1647) UNCOMPARABLE ACTUAL/USAGE FORMATS FOR DATETIME FIELD : CLOSEDDATE% This is the same format I have for all date fields. I have used the same usage and actual format on other synonyms with no issues. Any thoughts?This message has been edited. Last edited by: Tamra,
WebFOCUS 8 Windows, All Outputs
March 07, 2016, 08:10 PM
BabakNYC
You should never modify your ACTUAL. As long as you change the USAGE to a compatible format you should be fine. What's the data source?
WebFOCUS 8206, Unix, Windows
March 08, 2016, 10:07 AM
SAI_Ryan
I did not modify the actual (well i did try changing AFTER I received to error message to see if it had any effect. I gave me a different error message so I reverted back to original and now I'm back to getting the error message).
Data source is a view from our database.
WebFOCUS 8 Windows, All Outputs
March 08, 2016, 11:21 AM
BabakNYC
The view is in what kind of dbms? SQL Server, Oracle, DB2? If you create the synonym and don't change anything, does the synonym work?
What's the USAGE= and ACTUAL= generated by Create Synonym?
WebFOCUS 8206, Unix, Windows
March 08, 2016, 11:31 AM
SAI_Ryan
Sybase IQ is the DB.
Usage and Actual are Both HYYMDm by default when I create the synonym. If I leave it that way it works its when I change the usage format I start getting the error message.
WebFOCUS 8 Windows, All Outputs
March 08, 2016, 12:17 PM
BabakNYC
This just a guess but
USAGE=HYYMDmA, ACTUAL=HYYMDm
might work.
WebFOCUS 8206, Unix, Windows
March 08, 2016, 02:45 PM
SAI_Ryan
If I keep the miliseconds property I change the format however I want. The problem seems to rounding off of miliseconds to some other time.
Very perplexing why on other synonyms this isn't a problem.
WebFOCUS 8 Windows, All Outputs
March 18, 2016, 02:34 PM
Tamra
Hi SAI_Ryan,
Here are a few Techsupport links that deal with date time and seconds.
Page: 145 How to Describe a Time-Only Value USAGE = Htimefmt1
If you are having issues with the seconds then let us know by opening a case at the TechSupport Site.
Thank you for participating in the Focal Point Forum.
Kindest regards, Tamra Colangelo Focal Point Moderator - Information Builders Inc. * Summit 2016 – June 13-17 in Reno, Nevada - http://www.informationbuilders.com/events/summitThis message has been edited. Last edited by: Tamra,
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5