As I demonstrated, it has the time as well if the text string has the time.
I suspect you need to format the cell to show the time.
Today at noon would look like
? cdbl(cdate(date+timevalue("12:00")))
37840.5
If I put this in a cell
Range("B9").Value = cdate(date+timevalue("12:00"))
? range("B9").Text
8/7/2003 12:00
' but if I format the cell to just show date
Range("B9").NumberFormat = "mm/dd/yyyy"
? range("B9").Text
08/07/2003
' however, the time is still stored in the cell
? range("B9").Value
8/7/2003 12:00:00 PM
I suspect you are seeing formatted output and not look at what is actually
stored in the cell.
Regards,
Tom Ogilvy
"Bruccce" <(E-Mail Removed)> wrote in message
news:R1xYa.90594$YN5.64744@sccrnsc01...
> When I use cdate(TextBox_Attempt1Date) is only has the date, not the time.
> where TextBox_Attempt1Date has the date AND time. Is there a setting that
> controls cDate()?
>
> Bruce
>
> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > No reason not to use cdate:
> >
> > ? typename(cdate("01/01/2003 10:53 AM"))
> > Date
> > ? cdate("01/01/2003 10:53 AM")
> > 1/1/2003 10:53:00 AM
> >
> >
> > Regards,
> > Tom Ogilvy
> >
> > "Bruccce" <(E-Mail Removed)> wrote in message
> > news:NOvYa.88848$uu5.12702@sccrnsc04...
> > > I had this in my code
> > > ActiveCell.Offset(0, 8) = CDate(TextBox_Attempt1Date)
> > > and I wanted to include the time as well and changed it to
> > > ActiveCell.Offset(0, 8) = TextBox_Attempt1Date
> > >
> > > Now when i evaluate the cell<today() , I am always getting true, even
if
> > the
> > > value from yesterday is in the cell.
> > >
> > > How should I code this so that I get the date and time, but also so
that
> > the
> > > comparison with today() provides valid results?
> > >
> > > Thnaks
> > > Bruce
> > >
> > >
> >
> >
>
>
|
Similar Threads
