Quote Originally Posted by RobCrombie
Try editing your dates in the DB from 04/04/2005 to 04/Apr/2005
Do that with the other dates, and run the pgm again.
What exactly do you mean by this?

Dates cannot be edited and stored differently in a DB - they are stored in a quadword format that has nothing to do with the display presentation you see.

Most of the confusion I've seen on the forum about dates is directly related to this point. People think they are seeing dates a certain way and then construct weak queries around those assumptions.

I agree with you completely that using an APR instead of 04 format for month is clearly less ambiguous and will probably work for this person...

It's all about coming up with a date formatting concept that works and then using it consistently.