Greetings,
This one has me stumped! I have a database with a memo/long text field and in this field there are a bunch of time stamps and some text (for example, "2022-04-15 0945 In Production"). I have successfully extracted the time stamp in a query (using "Mid([Status],InStr([Status],"In Production")-18,11)") but I am not able to filter the result with either string or date criteria. I was trying to filter the data between 2 dates or a date greater than or equal to one of the dates but no matter what I do, I get the "Type mismatch in expression" or "Invalid Procedure Call". I've tried dissecting the date and rebuilding it as a string, changing the format in the field to date, used the # before & after the value etc., but to no avail even when I copy one of the results and placing it in the query criteria.
The data type in the original field is of course long text but I am stumped to figure out what is going wrong. It seems like filtering the resulting extraction is not possible? I hope some brilliant person can help solve this issue or explain why it is not possible. Thanks in advance!!!
Cheers,
Rod
This one has me stumped! I have a database with a memo/long text field and in this field there are a bunch of time stamps and some text (for example, "2022-04-15 0945 In Production"). I have successfully extracted the time stamp in a query (using "Mid([Status],InStr([Status],"In Production")-18,11)") but I am not able to filter the result with either string or date criteria. I was trying to filter the data between 2 dates or a date greater than or equal to one of the dates but no matter what I do, I get the "Type mismatch in expression" or "Invalid Procedure Call". I've tried dissecting the date and rebuilding it as a string, changing the format in the field to date, used the # before & after the value etc., but to no avail even when I copy one of the results and placing it in the query criteria.
The data type in the original field is of course long text but I am stumped to figure out what is going wrong. It seems like filtering the resulting extraction is not possible? I hope some brilliant person can help solve this issue or explain why it is not possible. Thanks in advance!!!
Cheers,
Rod