Getting date from various data

[BHawk]

Hello,

I have a linked table that contains numbers, text and date.

How can I set a condition that returns a date? In table date is in format dd/mm/yyyy.

Thank you for answer.

 

[jal]

I don't understand. Can you provide the "big picture" as to what you are trying to accomplish?

 

[BHawk]

I need to write a querry that returns date (as selected)

I use it further as condition for another table.

I hope you understand.