DCOUNT - date as a field only works when entered as a number
The problem does not seem to be so much on the database side as in the
formula. No matter what format I use in the database, the formula returns
#value! if I don't use "40087" (for october 2009) in the formula itself.
"Sean Timmons" wrote:
OK, try copying a blank cell, highlight the column, paste special/Add, then
enter the data
"jco" wrote:
Yes, I did.
"Sean Timmons" wrote:
Have you formatted the column as date first?
"jco" wrote:
I am using Windows 2007. In my database, the date (month and year) is a
column header. In the formula, if I enter the field in "" as "10/1/2009", or
"Oct-09", I get #VALUE!. However, if I enter the field as "40087", the
formula returns the correct result. Has anyone come up with this and know a
way around? I can come up with the number equivalent of each date, but since
I am not the end user of this file, it would be easier to be able to enter
the date.
|