The problem is if I enter a date 01/24/2007 12:00:00 AM,
I get the result as 1/24/2007 and not 01/24/2007.
Hence when I compare dates, there will not be any resulting data for the above given date?
What should I do to get the shortdate as 01/24/2007?Shortdate... So this is an Access question and not a SQL Server question?
No comments:
Post a Comment