Date and Time format

[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

 

[Michel Walsh]

Hi,


SELECT TimeValue( DateTimeField ) FROM somewhere



Assuming you are using a native Jet table inside Access.



Hoping it may help,
Vanderghast, Access MVP

 

[Bill Davis]

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

 

[Ken Snell]

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.

 

[Bill Davis]

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

.

 

[Ken Snell]

You're welcome.

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



.

.