What is the difference between Today() and Date() functions? If Access is not case sensitive, why did my new rule for conditional formatting require the use of all upppercase TODAY()? Why wouldn't it accept Date()?
Thank you
Scott Axton
@Reply 4 years ago
Today() should have failed. There isn't a Today() function.
There is Now() which will give you the current Date and Time
and Date() Which will give you the current Date only.
I don't know what you are doing with conditional formatting using the above. Access may be assuming that you created your own Today() function. Case doesn't matter. Access will convert it.
Try putting it in a query to try it out like below then run the query. You will get an error (ON THE LEFT)
The Date() and Now() produce the results (ON THE RIGHT)
FYI - I just inserted CustomerT because you have to have a table in the query to test things. You get a result for each customer in the table.
Scott Axton
@Reply 4 years ago
Scott Axton
@Reply 4 years ago
What are you trying to accomplish in your conditional formatting?
Maybe post a Screenshot to show us so we can help. See Image Uploads if you don't know how.
Kevin Robertson
@Reply 4 years ago
Today() is an Excel function. Also used in VB.NET.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.
