Inserting and modifying dates on SQLSERVER 7.0 ( danish format )
Posted on 2002-04-07
The case is :
I use SLQ Server 7.0 as database for my application and I'm trying to insert dates passes from a form into a datetime field in a table. However EVERYTIME I do so the dates get completely 'f..... up'. I've tried almost everything, ex. CreateODBCDate, Dateformat LSDateformat functions etc.
THE DATEFORMAT has to be dd-mm-yyy ( DANISH STYLE )
I think it maby has something to do with the Database settings...does anyone know how to set this up ?