Hi there, right now i'm working with a VB6 project that connects to a
SQLSERVER 2000 using a System DSN.

I discovered a problem that, i hope you can help me.

The problem is that, when i try to save a record with a date field - the
date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!!

Don't know why.

In order to save a record to DB i try to use val = cdec(val), where val is a
date value, and for strings values i just use val = "'" & val & "'", and so
on... for diferent types of fields.

Because i'm developing for a spanish environment i decided to convert dates
in the right format ("dd/mm/yyyy") and try to have regional settings that
match national language and location.

If anybody can help me, please i will appreciate it.

Felix.