Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 2690 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How does one go about modifying the date format within a Report Description?

robertjamesd

How do I modify the date format within a report's Report Description? The date is currently displayed in the following format: DD/MM/YYYY and I would like it to be displayed in MM/DD/YYYY.

Sophos Enterprise Console version 4.0.0.2362

:5420


This thread was automatically locked due to age.
  • 0

    Hello,

    are you referring to the output of a scheduled report?

    Formats are controlled by the Regional and Language Options of the user running the report. For a scheduled report this is usually SYSTEM on the management server (you see it in the footer on each page: Report prepared by [user]). The language is set in the Schedule tab.

    Depending on your OS version you can either use the Administrative tab on Regional and Language Options to set the desired format for the System accounts (local system, local service, and network service) or set the values in the registry (HKU\S-1-5-18\Control Panel\International). The value names are iDate, sShortDate, sShortTime and sTimeFormat. See these TechNet and JSI articles for details. Caution: Changing these settings might have unwanted effects.

    HTH

    Christian

    :5432
  • 0

    Thank you for your reply, Christian. After further investigation, the issue is still unresolved. Here are some additional details:

    -the improper date format (DD/MM/YYYY) is displayed next to "Report Description:" on all reports generated from within Report Manager, whether or not they are scheduled, created, or run manually.

    -If Properties are accessed for any of the listed reports, dates are displayed correctly (MM/DD/YYYY) on both the Configuration tab (under Reporting Period) and the Schedule tab.

    -reports display "Report prepared by myusername". I am a local administrator on a Windows Server 2003 Standard Edition SP2 x86 server.

    -Control Panel > Regional and Language Options > Short date is configured correctly as MM/DD/YYYY.

    -HKU\S-1-5-18\Control Panel\International displays the following values:

    iDate: 0

    sShortDate: M/d/yyyy

    sShortTime: key does not exist

    sTimeFormat: h:mm:ss tt

    Are there any particular files that I may need to edit in order to resolve this issue? For example, a style file similar to crepconf.xml or creplang.xsl?

    :5437
  • 0

    Are there any particular files that I may need to edit

    Not that I am aware of. Just checked the behaviour again on WinXP Pro SP3, Server 2008 SP2, Server 2008 R2 and Win7. In all cases SEC (and the report) pick up and use the settings correctly. I've even tried "weird" settings for sDate like MMMM-d/.yy and get something like October-1/.10 (but note that MMMM-d/.yyy - although it can be entered in R&LO - gives an EM Reporter viewer error "Bad date-time format string"). The setting takes effect immediately (i.e. for the next report run) so it's not hard to test.

    The Properties use the format (and language) in effect when SEC was started.

    Now I have to say that I'm on 4.5.0.9 and no longer have 4.0 available. So - please could someone still using SEC4.0 check this?

    Christian

    :5447