Today Function

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
 
S

shanesullaway via AccessMonster.com

Hey Dave,

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

Today()

HTH,
Shane
 
D

Dave

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
 
D

Dave

got it working - doing things the hard way as usual.
I just put =date() as the default value.

Thanks for the replies
d
 
M

missinglinq via AccessMonster.com

Today() doesn't work because there's no such function in Access!
 
S

shanesullaway 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
 
D

Dave

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
 
S

shanesullaway via AccessMonster.com

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...
 
Top