Alter table error - vba

Hello,

I've been trying a bunch of different things to get this to work and still getting the same error message. Any help would be appreciate!

Getting runtime error "3293"

Syntax error in ALTER TABLE statement

Please Login or Register  to view this content.

Thanks

I am trying to alter the column that is name effective date that is currently in text format to be in date/time