Re: DATE() Prompts ME for date!

Have you tried to compile your code?
Do you have your own function named Date()?
Do you have a module named Date?

--
Duane Hookom
MS Access MVP


"MsHlyl" <MsHlyl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F8AF095C-A1B7-430E-AC0A-713B711C5A5B@xxxxxxxxxxxxxxxx
> Gina, Thanks for the suggestion. I removed the brackets but it gave me
> the
> following error:
>
> "Undefined function Date in expression."
>
> Would you happen to have any further suggestions? I would appreciate any.
>
> Thanks!
>
> "Gina Whipp" wrote:
>
>> Try removing the brackets from around Date(), it thinks [ DATE() ] is a
>> field in your table/query and since it isn't it's prompting you to enter
>> it.
>>
>> DateDiff("d",[OPEN_DATE], Date())
>>
>> "MsHlyl" <MsHlyl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:6695591A-9493-44E0-A770-7D459A574C0E@xxxxxxxxxxxxxxxx
>> > Hello All,
>> >
>> > I am trying to calculate the age of an item by doing the following
>> > (where
>> > OPEN_DATE is a field in a table and DATE() is the current date):
>> >
>> > DateDiff("d",[OPEN_DATE],[ DATE() ])
>> >
>> > It is actually giving me the number of days difference, HOWEVER, it is
>> > prompting me for the current date rather than taking the system date.
>> > Can
>> > someone explain to me what I am doing wrong? Why isn't it using the
>> > system
>> > date? Why is it prompting me for the value?
>> >
>> > Thanks!
>> >
>> > MsHlyl
>>
>>
>>


.

Relevant Pages