Handling dates in VBA Question.

[no48]

The value in the cell is 2008-11-29

Why then does this code return a false?

Please Login or Register  to view this content.

If I switch the cell reference to

Please Login or Register  to view this content.

It returns a True.

Is there a certian date format I can use that will be recognized as such by both the worksheet, and the VBA macro?

[Richard Buttrey]

Hi,

Because in the first case the cell is NOT greater than 29 Nov 08. In the second case the cell IS greater than 21 Nov 08.

Why do you expect something different?

i.e. it's performing exactly as it should.

Do you perhaps want to change the > to a >=

Rgds

[solnajeff]

Hi

The mid function you are using returns a string so in itself it is difficult to make any comparisons with dates.

I am not sure how to do it completely in VBA but you could use the following code to make a valid comparison, using cells A1 B1 and C1.

Please Login or Register  to view this content.

Regards

Jeff

[Richard Buttrey]

Hi Jeff,

That's what I originally thought too. But entering the string "21Nov08" in a cell does in fact result in a valid excel date number. Excel is clearly very good at interpreting what one is trying to do!

Rgds

[no48]

Hi,

Because in the first case the cell is NOT greater than 29 Nov 08. In the second case the cell IS greater than 21 Nov 08.

Why do you expect something different?

i.e. it's performing exactly as it should.

Do you perhaps want to change the > to a >=

Rgds

I am not sure what you are saying. If the value in the cell is 2008-11-29, then that should be greater than 21Nov08.

In the second case, yes it should return a true. I mentioned that, because it seems to have no odd stuff happening when you aren't comaparing stuff from the worksheet.

[shg]

Try

Please Login or Register  to view this content.

[no48]

Try

Please Login or Register  to view this content.

Thanks, that works, though I had to change the naming style of the pictures from "21Nov08" to "2008-11-21", but that is fine.

[royUK]

Please mark the thread solved & rate the answers