Re: DateTime field showing unwanted Time
- From: "bhicks11 via AccessMonster.com" <u44327@uwe>
- Date: Wed, 02 Jul 2008 12:35:27 GMT
Access date field includes the time. If you are viewing the date with a
query or in control box you can use format:
format(datefield,"mmddyy")
Bonnie
http://www.dataplus-svc.com
dgifford wrote:
All of a sudden, my date fields are showing a datetime with the time portion
the same in every table and database I open.
The time portion is 12:17:04 AM regardless of what table or database I open.
If I run a query on a date field and convert it to a double format,
"cdbl([the date])", the number has no decimal portion!
The date is stored as a whole number.
If I enter a date in a datetime field the time is automatically appended to
the
date in the display but the time portion is not stored in the data file.
I am able to open the same mdb's on another computer, and there is no
problem with the date fields.
I have played with changing my system Regional Setting and problem still
exhists.
The only thing I was able to do is go into a database table design mode and
add shortdate to the format of each date field.
This fix is temporary because I do not want to have to change 100+ mdb's.
One strange thing I came across was: If I open a query view and enter
Expr1:CStr(#12/11/2002#)
then exit the field, the system automatically changes my
entry to Expr1: CStr(#12/11/2002 12:17:04 AM#).
This anomaly is being created by the OS or Access somehow!
Any suggestions will be greatfully appreciated.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-setupconfig/200807/1
.
- References:
- DateTime field showing unwanted Time
- From: dgifford
- DateTime field showing unwanted Time
- Prev by Date: Access 2007 - RunTime Problem Setting ...
- Next by Date: Re: DateTime field showing unwanted Time
- Previous by thread: DateTime field showing unwanted Time
- Next by thread: Re: DateTime field showing unwanted Time
- Index(es):
Relevant Pages
|
