monkeymagic2222
Technical User
Hi,
I know there are loads of entries on here about converting text fields to date fields in access sql. My problem is I have a text column that may contain either a date or a text string but I only want to query dates. e.g. the column issued_date could contain: 01/02/2009 or "Date tba"
Is there a way to query the text field for dates and ignore any with text in (avoiding the data type mismatch error).
My sql is:
SELECT capex.ID, capex.capex_no, capex.issued_date, capex.description, capex.value
FROM capex
WHERE FORMAT(CDATE(issued_date),'dd/mm/yyyy') >= #01/01/2009#;
Thanks.
I know there are loads of entries on here about converting text fields to date fields in access sql. My problem is I have a text column that may contain either a date or a text string but I only want to query dates. e.g. the column issued_date could contain: 01/02/2009 or "Date tba"
Is there a way to query the text field for dates and ignore any with text in (avoiding the data type mismatch error).
My sql is:
SELECT capex.ID, capex.capex_no, capex.issued_date, capex.description, capex.value
FROM capex
WHERE FORMAT(CDATE(issued_date),'dd/mm/yyyy') >= #01/01/2009#;
Thanks.