Aha Tom thanks.

What I was trying to do was get rid of the time aspect from a date,
such that I could compare two dates without having to worry about
whether it was at 8 in the morning or midday. Is this something that
you think vbShortDate could help with?

Thanks again

Madeleine
Tom Ogilvy wrote:
from the object browser in the VBE

Const vbShortDate = 2
Member of VBA.VbDateTimeFormat

so it is a member of the VBA type library.

However, it is a constant, not a data type, I don't see how you could
declare something as type vbShortDate. You would declare it as date and
format it as vbshortdate.

--
Regards,
Tom Ogilvy


"madeleine" wrote:

Hi

I'm hoping that someone can help me on this, I'm sure I must be going
mad, I'm trying to declare something as VbShortDate, I get told that I
need to include its type library, I can't actually find out what type
library it lives in.

Hopefully someone can tell me what box to tick in the references menu.

All help much appreciated.

Thanks

Madeleine