Hello,
I have shortdatetime fields stored on SQL Server. I pull that into a Cursor, and the cursor sees the 2 digit year instead of 4. How can I change that?

Here is the relevant code:

lnConnHandle=Sqlstringconnect("driver={SQL Server};server=SQLSRVB;uid=name;pwd=pass;database=db")
lcSQLConn = SQLEXEC(lnConnHandle, "SELECT * FROM members WHERE (active = 1 AND last_update > '1/1/1900')",'MEMBERS')
IF lcSQLConn = -1
	MESSAGEBOX("[ERR]Failure to connect to SQL Server MEMBERS")
	lcError = .T.
ENDIF
= SqlDisconnect(lnConnHandle)

TIA,
MAC