Date and Time format

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have data from an Oracle database that I have imported
into an Access Database. In the date field has the date
and the time MM/DD/YY HH:MM:SS. What is the easiest way
to remove the time from this field?
Thank you in advance
 
Hi,


SELECT TimeValue( DateTimeField ) FROM somewhere



Assuming you are using a native Jet table inside Access.



Hoping it may help,
Vanderghast, Access MVP
 
Michel,
I am stupid when it comes do Access.. Now how do I
removed that data with deleting the whole row?
Thanks bill
 
Create an update query. For the DateTimeField field, use this for the
"Update To:" value:
DateValue([DateTimeField])

That will convert the values to just date-containing values.
 
Ken,
Thank you!!
-----Original Message-----
Create an update query. For the DateTimeField field, use this for the
"Update To:" value:
DateValue([DateTimeField])

That will convert the values to just date-containing values.

--
Ken Snell
<MS ACCESS MVP>

Michel,
I am stupid when it comes do Access.. Now how do I
removed that data with deleting the whole row?
Thanks bill wrote
in message
Click to expand...


.
Click to expand...
 
You're welcome.

Bill Davis said:
Ken,
Thank you!!
-----Original Message-----
Create an update query. For the DateTimeField field, use this for the
"Update To:" value:
DateValue([DateTimeField])

That will convert the values to just date-containing values.

--
Ken Snell
<MS ACCESS MVP>

Michel,
I am stupid when it comes do Access.. Now how do I
removed that data with deleting the whole row?
Thanks bill
-----Original Message-----
Hi,


SELECT TimeValue( DateTimeField ) FROM somewhere



Assuming you are using a native Jet table inside Access.



Hoping it may help,
Vanderghast, Access MVP


in message
I have data from an Oracle database that I have
imported
into an Access Database. In the date field has the
date
and the time MM/DD/YY HH:MM:SS. What is the easiest
way
to remove the time from this field?
Thank you in advance



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top