Karen Schaefer
asked on
TypeMismatch when Converting number yyyymmdd to mm/dd/yyyy
I need to convert a number/date field from yyyymmdd to mm/dd/yy and I am getting a data type mismatch.
HIRE_DATE: DateSerial(Left$([EFFECT_H IRE_DATE], 4),Mid$([E FFECT_HIRE _DATE],5,2 ),Right$([ EFFECT_HIR E_DATE],2) )
what am I missing
HIRE_DATE: DateSerial(Left$([EFFECT_H
what am I missing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks that did it.
K
K
ASKER