I have a VB macro that allows a user to choose a date with DT picker 6.0 and
then inserts this value in the user form. I would like to only enter the
date that is chosen(not the time). Is there a way to not include the time
stamp using this control?

What are you doing that you are getting both the date and time from this control? When I use the Value property of the DTPicker control, and it is set to one of the time formats, I only get the date returned. What properties did you change and what code are you using? You need to show us something so we can duplicate what you are seeing.

--
Rick (MVP - Excel)


"Brian" <(E-Mail Removed)> wrote in message news:EDAEEB7E-006D-4F1D-BA67-(E-Mail Removed)...
>I have a VB macro that allows a user to choose a date with DT picker 6.0 and
> then inserts this value in the user form. I would like to only enter the
> date that is chosen(not the time). Is there a way to not include the time
> stamp using this control?

I think I already managed to sort it out. I was initializing to the current
date when the form opened with Now () which was setting current time as well.
I changed this to Int(Now()) and that seems to have done the trick
throughout.

Thanks anyway.

"Rick Rothstein" wrote:

> What are you doing that you are getting both the date and time from this control? When I use the Value property of the DTPicker control, and it is set to one of the time formats, I only get the date returned. What properties did you change and what code are you using? You need to show us something so we can duplicate what you are seeing.
>
> --
> Rick (MVP - Excel)
>
>
> "Brian" <(E-Mail Removed)> wrote in message news:EDAEEB7E-006D-4F1D-BA67-(E-Mail Removed)...
> >I have a VB macro that allows a user to choose a date with DT picker 6.0 and
> > then inserts this value in the user form. I would like to only enter the
> > date that is chosen(not the time). Is there a way to not include the time
> > stamp using this control?
>

In VBA, instead of using Int(Now()), you could use the Date() function which is like Now(), but without the time part.

--
Rick (MVP - Excel)


"Brian" <(E-Mail Removed)> wrote in message news:2AEA9038-DA6E-416F-B91C-(E-Mail Removed)...
>I think I already managed to sort it out. I was initializing to the current
> date when the form opened with Now () which was setting current time as well.
> I changed this to Int(Now()) and that seems to have done the trick
> throughout.
>
> Thanks anyway.
>
> "Rick Rothstein" wrote:
>
>> What are you doing that you are getting both the date and time from this control? When I use the Value property of the DTPicker control, and it is set to one of the time formats, I only get the date returned. What properties did you change and what code are you using? You need to show us something so we can duplicate what you are seeing.
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "Brian" <(E-Mail Removed)> wrote in message news:EDAEEB7E-006D-4F1D-BA67-(E-Mail Removed)...
>> >I have a VB macro that allows a user to choose a date with DT picker 6.0 and
>> > then inserts this value in the user form. I would like to only enter the
>> > date that is chosen(not the time). Is there a way to not include the time
>> > stamp using this control?
>>