View RSS Feed

100 Grades Per Minute

The professional blog of a Data and SIMS.net Administrator in a single-sex faith school. Contains the odd rant and bad geek joke.

  1. Using Dates in SIMS Reporting

    by
    CAM
    , 4th January 2012 at 07:12 PM (100 Grades Per Minute)
    When you output dates in SIMS with the Reporting tool, the results will come out as text and cannot be converted into a proper date with the number format window. This is a fix used in the SIMS Standard Portrait template to prevent Excel from throwing a fit and entering the data incorrectly. You can modify the template and remove the fix but that is best left to advanced users, there is a simpler option.

    Let's take a date in the format "1 March 2012" in cell C2. You can ...
    Categories
    Work , SIMS , Technical , Office