need to query one day ago....

[SilentBob_secretfusion]

Hi all...

I am trying to run a query which will pull records inserted yesterday and today. I have the today figured out, however was wondering if anyone has a simple solution to the yesterday. My current query is:

SELECT id2,dateofinsert
FROM dbo.tbl_parv2
WHERE (dateofinsert = '#dateformat(now(),'mm-dd-yy')#' ')

Thanks.

[Guest · Accepted solution]

You are looking for DateFormat(DateAdd("d", -1, Now()), "mm-dd-yy)

[SilentBob_secretfusion]

Thanks! 🙂