If you are unable to create a new account, please email support@bspsoftware.com

 

Extra comma and space after weekday name when formatting date/time data

Started by brian.brooks, 24 Jul 2012 10:49:25 AM

Previous topic - Next topic

brian.brooks

We're experimenting with publishing date/time stamp based fields from our database in multiple date formats from Framework Manager (formatted as month, weekday, hour, etc) so they can be pulled directly into the reports for added contextual information with little modification required. When engaging the Display Weekdays option and disabling all others (refer to screenshot for an example) we do get the day of the week, however it typically ends with a comma. If the content locale switches from English to German or Dutch or some other language, the comma will typically still display. French is a notable exception.

I need to know if there is a way to turn off the comma separator at the end of the weekday if possible. If not, I'd like to know if there is another way to display weekday from Framework based on an existing date/time stamp item which will maintain the content locale integrity.

Attached are some screenshots of what I'm seeing. I've been able to reproduce this in both 8.4.1 and 10.1.1.


brian.brooks

Here's a follow-up question for those of you who may have not run into this issue: if you currently report against a relational DB structure, how are you modeling a date/time field so that it displays the name of the week day?  Do you build out your own calendar table which has this information?  Does it have the translated week day name stored in the table as well?  What are some other solutions?

I've placed a ticket with IBM Support on this issue, and so far it's looking like this may be a bug, but if anyone has information that could point me in the right direction I'd greatly appreciate it!

ahmerzaidi

I believe you are able to use to achieve most of what you are trying to do using Cognos Function and with some combine using Data Format patterns. See the following link: http://www.temple.edu/ers/training_material/cognos_time_and_date_functions.pdf

This can also to acheived at a database level using a Date Dimensions table, it's up to you how much granularity you want.  By the looks of your attached image you lowest level would be seconds.