Comparing two dates in msaccess

Posted Date: 02 Jul 2009 Posted By: Abbas Member Level: Gold Points: 1 Responses: 1

Hi Friends,
I am Creating a simple web application with msaccess as a backend. i have took the registration details of the user with the expiration date set to 1 month after the date of registration. My Problem is when i check whether the expiration date is <(Less than) system's current date it shows me unexpected records. In Access i wrote the simple query for this as follows.


select * from tableName where expirationDate <= '02-July-2009'(Replaced with System date Code)

It shows me all the records of all the months whose date is <= 02. this Means it only Checks the Day Part of the Date. and ignores the Month and year Part. ExpirationDate field is string datatype but i also tried date/time datatype but no use. also i create the query replacing quotes by #, but got same results.
If you have any suggestion on doing this task do let me know soon.

Thanks in Advance
Abbas Electricwala

Responses

Author: Mohan 03 Jul 2009 Member Level: Diamond Rating: Points: 2

http://support.microsoft.com/kb/210276

Regards

Mohan Kumar.D

Post Reply

You must Sign In to post a response.

	Next : Build social networking site
	Previous : How to send data from c# file(.cs) to xslt file
	Return to Discussion Forum
	Post New Message
	Category: ASP.NET

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use