Re: New user needs help with dates in a table

You can either use the dafault format (MM/MM/YYYY HH:MM:SS.TTT in quotes if your target column is full DATETIME, or just date part if it is DATE), or set DBDATE environment variable to suit your taste. It seems that you need a column of DATETIME YEAR TO SECOND type. -- Dragi Raos 4-MATE Information Engineering (http://www.4mate.hr) Zagreb, Croatia