I have a table with a timestamp field which contains the date and time. ie.
9/13/2004 9:10:00 AM.
I would like to split this field into 2 fields, one with just the DATE
portion ie 9/13/2004
and the other with just the TIME portion. ie 9:10:00 AM.
I can make the table view display what I want by placing the same data in 3
fields and setting the display property to 'General Date',' Medium Time' and
'Short Date' but the underlying data in all fields is the same.
As simple as it sounds I can not find a simple way to accomplish this
besides highlighting half the field and using cut&paste to populate the new
fields.
One solution I have tried is to run an Update query to Set the new fields to
the time or date portion.
I can set the new fields to just about any single date or time module but
nothing to extract just the time or date portion. It seems there are
functions to extract the Day, month, day, hour, minute, etc.. but not the
date or time portions of a date time field.
any ideas would be helpful
Thanks BOB