Hi friends,

I try to update a table with system date. it does not work. no system date and time.
my query as
***UPDATE ADJFLAT SET ADJFLAT.ImportDate = Format(Date(),'mm/dd/yyyy')
however, i am still got system format of date and time
as 11/18/2003 0:00:00.

But i am only need to 11/18/2003 as output results


Thnaks!!!



Jimmy

That's because the field is a DateTime type - there's no such thing as a Date only field in Access. If you don't put in a time you get the default of midnight. Just ignore the time part when you display the field.

Jimmy

This has just been covered here: http://p2p.wrox.com/topic.asp?TOPIC_ID=6587


Brian Skelton
Braxis Computer Services Ltd.

Now, for my life, I can not recall how to get the time out of the datetime
When I do

Time: Format([dateone],"hh:nn ss")

only re turns
20:45
in military time. How do I get it to do the standart 8:45 PM
My brain is fried.




Sal

Try:
Brian Skelton
Braxis Computer Services Ltd.

I will be able to sleep tonight.

Thanks Brian.




Sal

If you just give Date(), it should return just date. I am doing that already.