I would like to be able to split a date field ActualDateTime to show date in one field and time in another field.
Field name is ActualDateTime
Table name is Travel
the date field will be Travel_Date
the time field will be Travel_Time . note that time would not be 24 hours.