Hello guys,
I have not been on here in a while.
I have a issue I am trying to solve.
I have data in a database that is formatted like this:
yyyy/mm/dd ...in text format
So I did this:
Which works fine...but when I try to filter on that information I get data mismatch.....??
I tried VAL() tried DateValue() tried Cdate()....nothing is working....what am I missing????:banghead:
Any Ideas??
I have not been on here in a while.
I have a issue I am trying to solve.
I have data in a database that is formatted like this:
yyyy/mm/dd ...in text format
So I did this:
Code:
DateSerial(Left([VACY_CONTE.INIT_PREM_EFF_DATE],4),Mid([VACY_CONTE.INIT_PREM_EFF_DATE],5,2),Right([VACY_CONTE.INIT_PREM_EFF_DATE],2))
Which works fine...but when I try to filter on that information I get data mismatch.....??
I tried VAL() tried DateValue() tried Cdate()....nothing is working....what am I missing????:banghead:
Any Ideas??