danielviau Absent Member.
Absent Member.
2868 views

Date format inconsistent in report preview vs generated

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 Likes
2 Replies
AutomaticReply Absent Member.
Absent Member.

Re: Date format inconsistent in report preview vs generated

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



0 Likes
danielviau Absent Member.
Absent Member.

Re: Date format inconsistent in report preview vs generated

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.