Date - 30 days

[Judy]

Hi all,

I'm trying to pull a query/view from an employee table with all active employees and employees who have terminated within the past 30 days. I've tried entering in the TermDate criteria field 'is null' or 'date() - 30'.

I'm also posting this message on the SQL message board since I am trying to create a view with these results.

Any help is appreciated!!

Judy

 

[ColinEssex]

Wouldn't it be something like

Is Null or Between Date()-30 and Date()

Col

 

[Judy]

Date Issue

Thanks Col!

That was it. I didn't use 'between', just date()-30. Big DUH for me today. Hope all is well and hope you have a great holiday!