Unanswered: How do I retrieved the last day of the month?
For example, let say currently it July 2003 and I want to pull up or get the value of the last day for June 2003. This validate if the days in my data has gone pass the last day of June 2003, which the Access won't accept when appending data to a table.
Last day of June 2003 is the 31. In some of the data show June 32, 2003, which is unacceptable for Access to accept it. These data was scan from a scantron paper to a table(from people handwriting), so I have no control over this. I can only validate the data before it goes into the table with the date/time fields. Hope this is understandable to read....
Wow, neat code. I have test it out and it work. I always use DateFormat when doing some type of date retrieval. Anyways, can you explain to me how this code works, like how did it retrieval the previous month and the last day of the previous?
I have try messing around with the value of the code and I don't see how this code retrieve the previous month and the last day of the previous. I would love to understand this code on how it works.