How to Decipher TIMESTAMP Field in .PJX Files

• Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a
• Microsoft FoxPro for MS-DOS, versions 2.5x, 2.6, 2.6a
• Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c

SUMMARY

Once you know the formula used to create the number that is used for the TIMESTAMP field in Project files, you can use that information to decipher the time stamp of existing records, or create your own time stamp.

MORE INFORMATION

To decipher the number, do the following:

1. Convert the number to a 32-bit binary number. For example,

         481522543
   

   becomes:

         0001 1100 1011 0011 0111 0011 0110 1111
   

   NOTE: Some calculators drop the leading zeros when they convert from decimal to binary, so make sure you have all 32 bits.

2. Use the following example to convert the binary number to a time stamp:

         YYYY YYYM MMMD DDDD HHHH HMMM MMMS SSSS
         0001 1100 1011 0011 0111 0011 0110 1111
   

         Y = year    = 0000 1110 = 14
   
         M = month   = 0000 0101 =  5
   
         D = day     = 0001 0011 = 19
   
         H = hour    = 0000 1110 = 14
   
         M = minutes = 0001 1011 = 27
   
         s = seconds = 0000 1111 = 15
   
   

3. The rightmost bit for seconds is missing, so change it in the following fashion to get the actual seconds to use in the final conversion:

         s = seconds = 0001 1110 = 30
   

   NOTE: This is the same result as multiplying the first value by 2, which means you will never have an odd number of seconds.

Everything else starts at 0, so your end result is 5/19/1994 14:27:30.