Re: datevalue

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? 
.

Relevant Pages

  • Re: "Currency" format lost in subform.
    ... As far as I can recall, you would need to use the format function to force ... the format in the underlying query for the combobox or the list box. ... It wont work when it is a subform it seems. ...
    (microsoft.public.access.queries)
  • Help with Date formats
    ... Dates were suplied in 4-21-1998 format. ... I need to calc the ... but the formula =MONTH-MONTHwont work. ... or change the date format of the supplied data? ...
    (microsoft.public.excel.misc)
  • Dating Advice
    ... Now there are 7150 records and I cannot really alter the date format ... to conform with the mysql YYYY-MM-DD format. ... format it wont work. ... in DD/MM/YYYY and to do its magic and work as if it was the norm. ...
    (comp.lang.php)
  • Re: OT: Unless F1 teams use Radeon cards under Ubuntu
    ... A database is a storage, a spreadsheet is used as a front ... so that reason would need to be sound. ... Those won't be VBA macros or very, ... to today's format forever. ...
    (rec.autos.sport.f1)
  • Re: wanted: PC/MAC C programmers (for apple II project)
    ... for no other good reason it's how I make a living. ... level of security to it to prevent or at least monitor that. ... the images to the alternate binary format on your own somehow. ...
    (comp.sys.apple2.programmer)