Hello,

I'm taking wildlife collar locations from Access into ArcGIS to map, and am having trouble merging the date and time fields into one.

My data is currently in this form (2 fields):
Date: m/d/yy
Time: 13:00

I'd like to have it in this form (1 field):
mm/dd/yyyy 13:00

Any suggestions would be greatly appreciated. My forehead bruises easily and I'm starting to notice the keyboard impressions.

Thank you!

try that
dateserial(2009,06,30) & " " & timeserial(11,00,35)



Sorry, i'm french and i'm a bad english

Thank you...
I'm confused how this will convert two different fields into one. The only place I've found where I can use this is as a custom format for one individual field. I can change the format of my date column, but it doesn't automatically pull in data from the time column. I think it's probably best that I just add another step and do this in (gasp!) Excel.

You do not need to use Excel. Maybe this link will help in understanding the Access DateTime field.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"