Thread: datevalue
View Single Post
  #2   Report Post  
Govind
 
Posts: n/a
Default

Hi,

Try

=DATEVALUE("31-Dec-2005")

It works.

Your first two values were within single quotes and hence they wont
work. On the third format, am not sure of the reason why it doesnt work,
but your date format should be in sync with your default date format set
in the Regional settings.

Regards

Govind.

LarryTheK wrote:

When I try to use the function DateValue, I keep getting an error message of
"wrong data type". I've tried many ways of entering the date: '12/31/05,
'12/31/2005, "12/31/2005", but none seem to work.

This was okay last year, but recently I get the error messages. Can someone
help?