please help with date problem

Hi

I use 2 datetimepicker in my form
and my insert look like this

"INSERT Into kursusplan ( startdato , slutdato ) VALUES (" & Me.Date_start.Value & " , " & Me.Date_slut.Value & ")"

But it is not the right date i get into my SQL DB
all the dates are in year 1894

I use dk format in my DB like dd-mm-yyyy

Can seomeone help

Alvin




Answer this question

please help with date problem

  • BobH2

    Have done it

    Alvin



  • olap_user

    Hi Alvin,

    I would appreciate if you could describe how you solved this problem as i am experiencing similar difficulties. (I have tried several formatting options).

    Regards in advance

    AndyJ



  • please help with date problem