Home

Results 1 to 3 of 3

Thread: Date format inconsistent in report preview vs generated

Threaded View

  1. #1
    Join Date
    Feb 2017
    Posts
    2

    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
    Last edited by danielviau; 17-Feb-2017 at 02:54 PM. Reason: Made typo in date when copying

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •