Date - 30 days

Judy

Registered User.
Local time
Today, 14:14
Joined
Sep 26, 2000
Messages
34
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
 
Wouldn't it be something like

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

Col
:cool:
 
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!
 

Users who are viewing this thread

Back
Top Bottom