Date() vs Now()

[jake7363]

Hi,
I am trying to run a query that selects all records for the current date. In one version of Office, it would work well with the Date() function. But in my Access 2002 version, the Date function is reported to be non-existant. So, I tried the Now() function, but obviously that relates to the current date AND time. I need to get the date alone.

How can I accomplish this?

Any help will be greatly appreciated.

Thanks in advance.
Jake

 

[The_Doc_Man]

Date function non-existant? I don't think so.

This smells like a references problem, and it often occurs that the missing function ISN'T the real problem. It is just the first named function that tripped over the function search.

Open a VBA code page. Create a new module if you have to do so to get to that page, but it would be easier if you already had a module available.

On the menu bar, follow Tools >> References and look for any MISSING references. (The word MISSING, all caps, will appear in the dialog box next to any unfindable references.) Uncheck the box for the missing reference.

Search this forum for "References" and "Missing References" to see tons of replies on how to search for the missing reference files including possible version-based name changes. It isn't at all uncommon to run into a .DLL file name change 'cause of an Office version change.

 

[jake7363]

Thanks, this was a start. I followed your suggestion and found that the missing reference was "shappmgr 1.0 Type library". I also searched the forum as you suggested, and although I found the problem mentioned a few times, nothing existed in the way of how to actually find the missing reference. Is there anything in MS Knowledge base I should look for? Right now, I am basically stuck.

Thanks again,
Jake

Date function non-existant? I don't think so.

This smells like a references problem, and it often occurs that the missing function ISN'T the real problem. It is just the first named function that tripped over the function search.

Open a VBA code page. Create a new module if you have to do so to get to that page, but it would be easier if you already had a module available.

On the menu bar, follow Tools >> References and look for any MISSING references. (The word MISSING, all caps, will appear in the dialog box next to any unfindable references.) Uncheck the box for the missing reference.

Search this forum for "References" and "Missing References" to see tons of replies on how to search for the missing reference files including possible version-based name changes. It isn't at all uncommon to run into a .DLL file name change 'cause of an Office version change.