I am trying to convert a timestamp (20200212091009) to the date 2-12-2020 in a query and I keep getting an error.
The following is the expression I have tried:
Finalize_Date: DateSerial
(Left([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],4),
Mid([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],5,2),
Mid([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],7,2))
and
CDate
(Left([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],4
& "/" &
Mid([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],5,2)
& "/" &
Mid([R09CABPRD_CAR_MOVE]![VC_VAR_FLD1],7,2))) AS Finalize_Date,
I am at a loss at this point, any help would be appreciated.
TIA
Lisa