DTPicker - time is also save do the DB - I don't want this!!!

[MTuma]

Hi!!!

I have a Problem with the DTPicker - I use it in a VB6-Form with a SQL7-DB. I just want to save the date - without the time - i tried several times to format the DTPicker - I couldn't find a solution!!!

Please help urgently!!!

Thank you !!!

[HeSaidJoe]

Format(datepickerwhatever,"yyyymmdd")

[James Stanich]

Set format to dtpShortDate?

[MTuma]

Hi HeSaidJoe, hi James Stanich!

I have tried this already - if you select the date form the dtpicker (with the pull-down calender) then the dtpicker sends the time with ...

Markus

[Edited by MTuma on 09-26-2000 at 10:32 AM]

[MTuma]

Originally posted by James Stanich
Set format to dtpShortDate?

Hi HeSaidJoe, hi James Stanich!

I have tried this already - if you select the date form the dtpicker (with the pull-down calender) then the dtpicker sends the time with ...

Markus

[HeSaidJoe]

HI,
Where is the dtpicker under components so I can pull it
down and see what happens?

[MTuma]

Originally posted by HeSaidJoe
Format(datepickerwhatever,"yyyymmdd")

Hi HeSaidJoe, hi James Stanich!

I have tried this already - if you select the date form the dtpicker (with the pull-down calender) then the dtpicker sends the time with ...

Markus

[MTuma]

Originally posted by HeSaidJoe
HI,
Where is the dtpicker under components so I can pull it
down and see what happens?

It's very nice that you help me!!!

You can find it under components, controls, Microsoft Windows Common Controls-2 6.0 (SP3)

[HeSaidJoe]

'I don't get any time...just a date in the visual
'and if I click down the calander and click a date
'all I get is that data.

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

[MTuma]

Originally posted by HeSaidJoe
'I don't get any time...just a date in the visual
'and if I click down the calander and click a date
'all I get is that data.

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

Wenn I drag/drop the DTPicker in the Watches-Tool I get for example 10.10.2000 16:45:02

How can I format this ???

[MTuma]

Originally posted by HeSaidJoe
'I don't get any time...just a date in the visual
'and if I click down the calander and click a date
'all I get is that data.

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

When I do this:

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

I get 26.09.2000 16:54:15

[HeSaidJoe]

Private Sub DTPicker1_Change()
    MsgBox DTPicker1.Value
End Sub

Private Sub Form_Load()

    DTPicker1.Format = 0

End Sub

[MTuma]

Originally posted by HeSaidJoe
'I don't get any time...just a date in the visual
'and if I click down the calander and click a date
'all I get is that data.

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

I got it!!!!!

The trick is that the value property must be set to a date, if it is emtpy you get the time too it you change the dtpicker-value!

Thank you very much!!!

Greetings from Austria!