Today Function

[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

 

[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

 

[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

 

[Dave]

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

Thanks for the replies
d

 

[missinglinq via AccessMonster.com]

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

 

[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

 

[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

 

[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().

[quoted text clipped - 7 lines]