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

Date format inconsistent in report preview vs generated

MigrationDeletedUser over 7 years ago

Using this simple report definition:
SELECT name, create_time
FROM srs.current_fs_scandata_ad
WHERE path_type = 1
LIMIT 1
Produces the expected result in the report definition interface:
name create_time
------ -------------------------
319011.SPC 2004-02-01 11:40:29

But when running the report (preview or stored report), the date format is different (non-ISO):
"319011.SPC",2/1/2004 4:40:29 PM

I checked by remote desktop the server's regional settings which I suspected and they were effectively set to using the AM and PM short date format so I changed them.
I ran the test again but the date problem remains. Possibly the server settings must be changed locally by the admin (that's my next step but we're a large organization and this may take weeks...)

So I wonder if anyone can tell me if there's a setting somewhere in File Reporter that can set the date formats used in the reports to the normal ISO format (no AM PM suffixes)?

Thanks!

Daniel

0 MigrationDeletedUser over 7 years ago

danielviau,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:

- Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
all the other self support options and support programs available.
- Open a service request: https://www.microfocus.com/support
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.microfocus.com)
- You might consider hiring a local partner to assist you.
https://www.partnernetprogram.com/partnerfinder/find.html

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.microfocus.com/faq.php

Sometimes this automatic posting will alert someone that can respond.

If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot.

Good luck!

Your Micro Focus Forums Team
http://forums.microfocus.com
Cancel
Vote Up 0 Vote Down

Cancel
0 MigrationDeletedUser over 7 years ago in reply to MigrationDeletedUser

A colleague contacted the MFR team and it seems that this problem is now recognized as a bug. A fix should be available in an upcoming release.

Daniel Viau
Montreal
Cancel
Vote Up 0 Vote Down

Cancel

Menu

File Reporter Discussions

Date format inconsistent in report preview vs generated

Resources