Concert date in text to date format for between parameter

[neil.mclean]

Could anyone please help. I'm importing from a linked table a date field that
is in text format. I need to create a report which has the between dates
paramater function. I believe I should be using CDate but don't know what to
do with it. Thanks in advance for your help