How to Identify a Bad Date in an Access Query

Submit Your Tip

How to Identify a Bad Date in an Access Query – This is a place for the community to provide tips and advice on How to Identify a Bad Date in an Access Query. This topic was created by laurent Cherif and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Tip 1 - How do I get valid dates, like using the ISDATE function without removing Null values?

Published: 9 years, 1 month(s) ago | Submitted by arif ishaque | permalink

Good day everyone! I am using the T-SQL ISDATE() function with a date column as argument to filter out bad dates; the problem is the ISDATE function will return zero when it comes across a NULL va...

For further reading: http://stackoverflow.com/questions/10558200/how-do-i-get-valid-dates-like-using-the-isdate-function-without-removing-null-v ^[1]

Tip 2 - Get the week number from a given date

Published: 9 years, 1 month(s) ago | Submitted by Jim Norris | permalink

Examples: 'DD/MM/YYYY "1/1/2009" should give `1` "31/1/2009" should give `5` "1/2/2009" should also give `5` Format("1/2/2009", "ww") returns 6. So, how can I get the correct result?

For further reading: http://stackoverflow.com/questions/1649720/get-the-week-number-from-a-given-date ^[2]

Tip 3 - Access SQL query: find the row with the most recent date for each distinct entry in a table

Published: 9 years, 1 month(s) ago | Submitted by OA Cheater | permalink

All, I'm sure this is a pretty simple SQL query question, but I'm sure there's a good way, and a very BAD way, to do this. Left to my own devices, I'm liable to end up with the latter. So... I h...

For further reading: http://stackoverflow.com/questions/1704260/access-sql-query-find-the-row-with-the-most-recent-date-for-each-distinct-entry ^[3]

Tip 4 - SQL SERVER – Validate Field For DATE datatype using function ISDATE()

Published: 9 years, 1 month(s) ago | Submitted by Peter Cifuentes | permalink

This article is based on the a question from Jr. Developer at my company. He works with the system, where we import CSV file in our database. One of the field in the database is DATETIME field. Due to architecture requirement we insert all the CSV fields in the temp table which has all the…

For further reading: http://blog.sqlauthority.com/2007/07/12/sql-server-validate-field-for-date-datatype-using-function-isdate/ ^[4]