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