filter on text date

[aftershokk]

I have a text date as follows:

09192002

I want to convert to a date and be able to filter by date ranges. I have searched this forum for about an hour and nothing is working.

I am using this:

New Effective Date: CDate(Left([pho_dir]![EFF_DT],2) & "/" & Mid([pho_dir]![EFF_DT],3,2) & "/" & Mid([pho_dir]![EFF_DT],5,4))

but

when I add a filter like >=7/1/2007 and get a data type mis,match error

help???

 

[boblarson]

I have a text date as follows:

09192002

I want to convert to a date and be able to filter by date ranges. I have searched this forum for about an hour and nothing is working.

I am using this:

New Effective Date: CDate(Left([pho_dir]![EFF_DT],2) & "/" & Mid([pho_dir]![EFF_DT],3,2) & "/" & Mid([pho_dir]![EFF_DT],5,4))

but

when I add a filter like >=7/1/2007 and get a data type mis,match error

help???

If you've converted the field to a date (the CDate does that) you would then need to reference it as a date in the criteria:
>=#7/1/2007#

 

[aftershokk]

does not work

no luck

see word attachment - thanks

 

[boblarson]

I see you have CVDate not CDate. The function is CDate.

 

[aftershokk]

still no luck

see attached

 

[aftershokk]

I figured it out!

thanks BOB as always..........