Today Function

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

how is this function called in the code?
I want to use in in an update query that is coded to a button.

thanks
 
Hey Dave,

I hope I'm understanding what your asking for but I think this is what you
are looking for:

Today()

HTH,
Shane
 
Well I think it is either
Today()
or Date()
not sure which and not sure how to use it in the code.
I want to use it in an update query
 
got it working - doing things the hard way as usual.
I just put =date() as the default value.

Thanks for the replies
d
 
Today() doesn't work because there's no such function in Access!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Your right. I didn't even check to see what I typed. I meant to type Now().
Why Today() came out instead, I have no idea. I guess I must have drank my
bath water yesterday. Sorry, Dave, for not paying attention any better than
that and thank you missingling for catching it.

Shane
 
Its all good.
The real problem is that I was trying to put it in the wrong place.
Date() worked great

I am not sure but I think Now() includes time along with the date.

Thanks again'
Dave
 
You are correct. Now() returns both date and time.

Shane
Its all good.
The real problem is that I was trying to put it in the wrong place.
Date() worked great

I am not sure but I think Now() includes time along with the date.

Thanks again'
Dave
Your right. I didn't even check to see what I typed. I meant to type
Now().
Click to expand...
[quoted text clipped - 7 lines]
Click to expand...
 
Back
Top