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!