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

Whats wrong with this query?

8 Views

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?

thanks

SV Reddy