Datevalue Error

[Pierre Scerri]

Hi

This line of code:

a=Datevalue("01 MAY 09")

is giving me a Type Mismatch error.

It was working before I re-installed Windows XP and Office 2003.

I have XP and Office SP3 as before. The refences in the VBA editor seem to
be all there.

Am I missing something?

Thanks

Pierre Scerri

 

[Michael Bauer [MVP - Outlook]]

I think that depends on your language setting. For me the German term works,
the English one doesn't.


--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 2 May 2009 07:52:01 -0700 schrieb Pierre Scerri:

 

[Pierre Scerri]

Thanks. That was it.

I think that depends on your language setting. For me the German term works,
the English one doesn't.


--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 2 May 2009 07:52:01 -0700 schrieb Pierre Scerri: