ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting right date value (https://www.excelbanter.com/excel-programming/438769-getting-right-date-value.html)

Robert Crandal

Getting right date value
 
I setup my DTPicker control to be used only
as a date control, yet I'm noticing that sometimes
it will give back a date AND a time all in the
same "value" variable.

Since it appears that a variable of type "Date"
can give back both a date and time, how can I
eliminate the time half of a date value???

I might not be able to exactly control the DTPicker
control to give me JUST a date, so I'm just curious
what to do if it gives me back both a date & time.


thank u



michdenis

Getting right date value
 
Hi,

Try this :

Dim x as date
x = cdate(clng(DTPicker1.value))



"Robert Crandal" a écrit dans le message de groupe de discussion :
...
I setup my DTPicker control to be used only
as a date control, yet I'm noticing that sometimes
it will give back a date AND a time all in the
same "value" variable.

Since it appears that a variable of type "Date"
can give back both a date and time, how can I
eliminate the time half of a date value???

I might not be able to exactly control the DTPicker
control to give me JUST a date, so I'm just curious
what to do if it gives me back both a date & time.


thank u



All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com