Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to check a field for errored date format?

Posted on 2011-03-03
3
Medium Priority
?
274 Views
Last Modified: 2012-06-27
I have a query that convert a string to a date format, how can i filter it to show only data that is not a correct date format. Normally the field shows #Error.
0
Comment
Question by:tvae
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35028307
select * from table where isdate(field)=false
0
 

Author Comment

by:tvae
ID: 35028480
derekkrom,

I have tried this one

IsDate(CDate(Left(Right([FOB_POINT],8),2) & "/" & Mid(Right([FOB_POINT],8),3,2) & "/" & Right(Right([FOB_POINT],8),4))) = False

And it gives me too complex error
0
 

Author Comment

by:tvae
ID: 35028537
Disregard the above. I got it to work when i took the cdate

IsDate((Left(Right([FOB_POINT],8),2) & "/" & Mid(Right([FOB_POINT],8),3,2) & "/" & Right(Right([FOB_POINT],8),4))) = False
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question