Hi All,
I have a text format field with name “Finalized” that takes values as date format (dd/mm/yyyy) or other simple text or remains blank. I try to make a query (from query builder) counting the records with date> current date. For this I use the formula:
The above works fine only if field “Finalized” contains date values for all records. If in a record the field “Finalized” is blank or contains different text than a date format I take error msg. I tied also isdate function without success. Please help.
Thanks in advance.
I have a text format field with name “Finalized” that takes values as date format (dd/mm/yyyy) or other simple text or remains blank. I try to make a query (from query builder) counting the records with date> current date. For this I use the formula:
Code:
Exp1: DCount("[CountryofOrigin]","MainTbl","[CountryofOrigin]='ITALY' And DateValue(Left([Finalized],10)) < DATE()").
The above works fine only if field “Finalized” contains date values for all records. If in a record the field “Finalized” is blank or contains different text than a date format I take error msg. I tied also isdate function without success. Please help.
Thanks in advance.