Framework Manager Formatting

[UcfMike]

I took the time to format the dates in the business view of our sales model. This was friday and everything worked fine. Today I'm working on a new model, which is a copy of the sales model. In botht the sales and new model, the formatting properties are correct, but the data when retrieve in either Framework Manager or Report Studio, doesn't display with the formatting. Has anyone run into this before?

 

[blom0344]

In framework manager the formatting of date/time cannot be tested. You need to publish a new package with the formatting set and then it works as designed in report studio.

Ties Blom

 

[UcfMike]

But I'm noticing in Report Studio that it's only working part of the time.

 

[sln007]

That's odd. I've set virtually all date fields, in FM, to MM-DD-YYYY (Show Century, 2-digit Month, 2-digit Day) and it's been consistent and functioning. I'll keep a watch out for strange behaviour.

Steve N.
State of Ohio, MIS

 

[CognosProfessional]

Everything works best by casting in the FM to YYYY-MM-DD
Then formatting anything from there in RS.

CP

 

[JPCogAdmin]

I'd say this, Do the formatting in RS.
For Best practice, use RS for formatting and FM for modeling your data.

-Jim