I'm converting a bunch of tables from Access to SQL Server and am required to run a script to ensure all the converted data converts properly. So, I need to compare a date field in Access to the corresponding date field in SQL Server. Although both are defined as datetime fields, I know that they are stored differently. Therefore, every compare of one to the other is always "not equal". What is an easy way to compare only the mm/dd/yyyy part of the two dates and get an "equal" when this part of the dates match.
Thanks, Eddie