G
Guest
Ihave the following expressions in my query. I trying to convert a stiring
date into a real date. format is 20050727
This one works fine.
LetDate: CDate(Left([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],4) & "/" &
Mid([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],5,2) & "/" &
Right([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],2))
This one returns an error. Does anyone know why? I've tried typing fied
names in uppercase as in the first expression.
TMBG: CDate(Left([public_t_cont_key_dt_1].[actl_dt],4) & "/" &
Mid([public_t_cont_key_dt_1].[actl_dt],5,2) & "/" &
Right([public_t_cont_key_dt_1].[actl_dt],2))
date into a real date. format is 20050727
This one works fine.
LetDate: CDate(Left([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],4) & "/" &
Mid([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],5,2) & "/" &
Right([PUBLIC_T_CONT_CRIT_DT].[ACTL_DT],2))
This one returns an error. Does anyone know why? I've tried typing fied
names in uppercase as in the first expression.
TMBG: CDate(Left([public_t_cont_key_dt_1].[actl_dt],4) & "/" &
Mid([public_t_cont_key_dt_1].[actl_dt],5,2) & "/" &
Right([public_t_cont_key_dt_1].[actl_dt],2))