imported date (text) is 2003-03-24:1220 (GMT Time, but illrelevent)
DateSerial (Clint(Mid$([Date_Field],6,2)), Clint(Mid$([Date_Field],9,2)), Clint(Mid$([Date_Field],1,4))) + Time Serial Clint(Mid$([Date_Field],122)), Clint(Mid$([Date_Field],14,2)),0) returnes 5/26/2010 12:20:00 PM
Mid$([Date_Field],6,2) & "/" & Mid$([Date_Field],9,2) & "/" & Mid$([Date_Field],1,4) returns 03/24/2003 (time not done to keep simple for troubleshooting).
Table is set for text, the table the records are appended to has the fields set for long date. Am trying to get the full, correct date and time in the same field.
Workstation date is correct, time is off by 4 hr, but I can't change (and it is not yet important to the administrator).
Anyone see what I am doing wrong?
TIA
Ron
mailto:ronald.kellis@us.army.mil
DateSerial (Clint(Mid$([Date_Field],6,2)), Clint(Mid$([Date_Field],9,2)), Clint(Mid$([Date_Field],1,4))) + Time Serial Clint(Mid$([Date_Field],122)), Clint(Mid$([Date_Field],14,2)),0) returnes 5/26/2010 12:20:00 PM
Mid$([Date_Field],6,2) & "/" & Mid$([Date_Field],9,2) & "/" & Mid$([Date_Field],1,4) returns 03/24/2003 (time not done to keep simple for troubleshooting).
Table is set for text, the table the records are appended to has the fields set for long date. Am trying to get the full, correct date and time in the same field.
Workstation date is correct, time is off by 4 hr, but I can't change (and it is not yet important to the administrator).
Anyone see what I am doing wrong?
TIA
Ron
mailto:ronald.kellis@us.army.mil