Skip to Content
Former Member
Jul 22, 2005 at 06:26 AM

SQL Query - Getdate ( ) Issue



I cant seem to get the GETDATE( ) to work with SBO, and I've tried it on a few diffrent patch levels.

My SQL query is as below:

SELECT T0.DocNum, T0.DocDueDate, T0.CardCode, GETDATE( ) [Today] FROM ORDR T0
WHERE T0.DocDueDate = GETDATE ( )

Now I know the GETDATE ( ) works because if I comment out the 'WHERE' line, the [Today] column shows up correctly.

Anyone have any ideas on this?

Thank you in advance!