Datevalue Error
 

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

Datevalue Error
 

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:

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

Datevalue Error
 

Thanks. That was it.

"Michael Bauer [MVP - Outlook]" wrote:



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:

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