Date data type in general consists of a date portion and a time portion
What if I try to compare A & B, where both are of type date but B=time (which only gives the system time without a date portion)
How does excel evaluate a comparison like that? Does it default the date portion of B as the current date first before it tries to evaluate ?
Read this...
How Excel Stores Dates And Times
It's a numeric comparison. A Time-only value has zero as a date.
If you put a Date-Time value in a cell and change the cell format to number, you can see the numeric value for that Date-Time.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks