This project has moved. For the latest updates, please go here.

My first post

Developer
Jun 27, 2014 at 4:39 PM
My name is José. Although I am not a professional, Crystal did me the great honor to participate in this project.

I live in France (and I really can speak only french) and I was immediately confronted with the problem of date and time: "Syntax error in date in the phrase" # 26/06/2014 10:53:00 ".

I replaced wholes occurrences of:
  '------------------------------------------------- - record test start time
    'sSQL = "INSERT INTO a_DbTests (testid, dbid, dtmTst1, Timer1)" _
    '& "SELECT" & _ pTestID
    '& "," & _ PDbID
    '& "#" & Now () & "#" _
    '& "," & CLng (Timer ()) _
    '& ";"

   by:
   sSQL = "INSERT INTO a_DbTests (testid, dbid, dtmTst1, Timer1)" _
       & "SELECT" & _ pTestID
       & "," & _ PDbID
       & ", Now ()" _
       & "," & CLng (Timer ()) _
       & ";"

I no longer have the error in the date at startup. But there is probably better to do.
I suggest that when using DateDiff, we systematically added parameters: vbUseSystem = 0

This project is very ambitious and I can only stay in the shadow of giants.