Promblem With 'Date/Time' Date Type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a field name called: Party Date and its format is set to 'Short Date'
and default Value Is 'Now()' The problem i am getting is that this stores the
whole date and time i.e as follows: '17/06/2005 17:33:00' I want the value to
be stored as '17/06/2005' without the time as well. How do i go about
changing this? Your help would be much apprecaited :)
 
Change the Default Value to:
=Date()
That's today's date without the time.

That fixes records in the future. To fix your existing ones as well, create
a query that uses this table. Change it to an Update query (Update on Query
menu.) In the Update row under the Party Date field, enter:
DateValue([Party Date])
Run the update query, and it will replace the date/time with just the date.
 
Ben

In addition to Allen's solution suggestions, please note that what is
stored, and how it is displayed in forms, queries, and reports are two
different things. You can keep the data you have (with the date & time
value, and chose to display (i.e., format) only the date portion.

If your application/situation has a need (or potential future need) to track
date AND time, don't throw out the time portion just to get it "looking
right".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top