Skip to Content
Mar 19, 2009 at 06:59 AM

Whats wrong with this query?


Hi All

I am trying to generate an alert for stores department when there is a new production order document is generated either planned or released status.

I am using the following query but it is not displaying any results even after generating a new production order document.

SELECT T0.[DocNum], T0.[ItemCode], T0.[PlannedQty], T0.[PostDate], T0.[OriginNum], T0.[CardCode] FROM OWOR T0 WHERE T0.[PostDate]=getdate()

Is there any wrong with the query?


SV Reddy