+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, SIMS Report in Technical; Hi, We've run a SIMS report into Excel and whereas everything is fine, we can't change the date format.. I ...
  1. #1
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    877
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    36

    SIMS Report

    Hi,

    We've run a SIMS report into Excel and whereas everything is fine, we can't change the date format..

    I think I'm being quite thick here, does anyone have any advice?

    Cheers

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,254
    Thank Post
    181
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    I believe date formats in Excel have always been a problem.

    Does it need to be in Excel instead of RTF with a choice of date formats?

  3. #3

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,059
    Thank Post
    375
    Thanked 375 Times in 306 Posts
    Blog Entries
    8
    Rep Power
    177
    Massive problem for ages (although hardcoded dates should be fine, like dates of birth). The biggest culprit were user defined fields that were dates, and were always coming out in American format if the day date was less that 13, otherwise it would be fine, which was actually worse! We got around it by putting into an RTF and the copy into Excel which then gave correct results.

SHARE:
+ Post New Thread

Similar Threads

  1. Sims Assessment Report
    By Ecalpemos2000 in forum MIS Systems
    Replies: 2
    Last Post: 9th December 2009, 03:45 PM
  2. Sims Report with Photos
    By Geoff in forum MIS Systems
    Replies: 8
    Last Post: 18th September 2009, 10:24 PM
  3. Sims report help
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 4th October 2008, 04:34 PM
  4. Sims report Template
    By imiddleton25 in forum MIS Systems
    Replies: 1
    Last Post: 27th June 2008, 05:08 PM
  5. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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