How to Identify a Bad Date in an Access Query

submit to reddit

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.

Votes

Tips

1
- Vote
Tip 1
How do I get valid dates, like using the ISDATE function without removing Null values? More
Published: 9 years, 3 month(s) ago by arif ishaque | permalink
Vote
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]

1
- Vote
Tip 2
Get the week number from a given date More
Published: 9 years, 3 month(s) ago by Jim Norris | permalink
Vote
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]

1
- Vote
Tip 3
Access SQL query: find the row with the most recent date for each distinct entry in a table More
Published: 9 years, 3 month(s) ago by OA Cheater | permalink
Vote
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]

1
- Vote
Tip 4
SQL SERVER – Validate Field For DATE datatype using function ISDATE() More
Published: 9 years, 3 month(s) ago by Peter Cifuentes | permalink
Vote
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]

About Author

More by laurent Cherif

How to Prevent Animals in Africa From Becoming Extinct

About This Topic

Category: Fun | 9 years, 3 month(s) ago

4.6k+ Reads

4 Tips

4 Votes

0 Likes

0 Saved

Contributors

Jim Norris, OA Cheater, arif ishaque, Peter Cifuentes

References & Citations

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

2. http://stackoverflow.com/questions/1649720/get-the-week-number-from-a-given-date

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

4. http://blog.sqlauthority.com/2007/07/12/sql-server-validate-field-for-date-datatype-using-function-isdate/