[FONT=Verdana, Arial, Helvetica][FONT=Verdana, Arial, Helvetica] Dear All,
I am creating a report to get the last transaction done between today and the last 14 days
My where clause is like this:-
WHERE (date_posted >= GETDATE()) AND (date_posted <= GETDATE() - 14)
for some reason its not working fine
Is the syntax correct?[/FONT][/FONT]
I am creating a report to get the last transaction done between today and the last 14 days
My where clause is like this:-
WHERE (date_posted >= GETDATE()) AND (date_posted <= GETDATE() - 14)
for some reason its not working fine
Is the syntax correct?[/FONT][/FONT]