Tip of the Month - February, 2001

Date formats - Adaptive Server Anywhere/SQL Anywhere vs. SQL Server

When performing an adhoc search and searching on a date field within iMIS, please be aware that there is a difference between how Adaptive Server Anywhere/Sybase SQL Anywhere and Microsoft SQL Server handle date formats. 

Adaptive Server Anywhere/Sybase SQL Anywhere must have the date entered as YYYY-MM-DD and Microsoft SQL Server must have the date entered as MM/DD/YYYY.