I want to build a query that I can run on a daily basis (in an automated script), that’ll show me reports that were created yesterday.
something along the lines of SELECT * FROM CI_INFOOBJECTS WHERE SI_UPDATE_TS > DATEADD(DD,-1, GETDATE())
But it looks like using GETDATE() does not work.
Is there any way of using a dynamic parameter to do what I’m trying?
ethan1701 (BOB member since 2004-05-05)