Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


Computer Date Format

Solution

ISSUE

The date format of the PC is changed and the application is crashing showing that the database table does not exist. The date displayed is in MM/DD/YYYY format.
 

TimeTrack needs dd/mm/yyyy format, but understands that there are some applications which will work only if mm/dd/yyyy format is available. So TimeTrack can either

  • change the date format permanently OR
  • change the date format while it starts to run and again revert back to the original format when it closes.

CAUSE

Can be any one of the following 3 reasons

  • TimeTrack has set some default wrong format.
  • Any one of your applications is changing the date format.
  • Your central server is changing the date format.

SOLUTION

  • Ensure TimeTrack does not have date format issues.
    • Delete the sysdateformat.set in TimeTrack\Set Folder
    • In Computer 
      • If OS is XP and Before - Go to Control Panel -> Regional & Language Settings -> Customize -> Date. Short Date format enter as dd/mm/yyyy.
      • Latest OS - Go to Control Panel -> Clock, Language & Region  -> Region & Language -> Change the date, time or Number format -> Additional Settings -> Date. Short Date format enter as dd/mm/yyyy.
    • Start TimeTrack. Go to Attendance Entry. Date Format would be shown. Download the punches and there wont be any errors.
    • If this fails check the next step.
  • Your server is setting the date format periodically.
    • Change the date format as mentioned in the above setup.
    • Dont  use your PC for may be 30 mts to One hour.
    • Check the date format. If it has changed, your server is syncing the time and its changing the date format.
    • Check the date format after stating the PC first time in the morning.
    • Contact your IT team if the date format changes within 30 mts when the PC is idle.
    • If the date format does not automatically change then go to the next step.
  • Any one of your applications is changing the date format.
    • Identify any applications you open simultaneously with TimeTrack and avoid opening the applications.


key: Date Format

 
Was this article helpful? yes / no
Related articles Out of Range DateTime Value
Software crashes while downloading punches
Data download error - tbl_master_HolidayXX
Delete Employee
License Issues
Article details
Article ID: 25
Category: TimeTrack General
Date added: 16/10/2012 12:47:11
Views: 692
Rating (Votes): Article rated 3.7/5.0 (9)

 
« Go back