Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aged0to30Days 1

Status
Not open for further replies.
beth4530

beth4530

Technical User
May 5, 2011
44
US
How do I write this so it will work?

Not isnull( Aged0To30Days({tblIncidents2003_2.Inc_date}))
 
Sort by date Sort by votes
What are you trying to do?

Normally you would use it like this

If {orders.ORDER DATE} in Aged0To30Days Then
{orders.ORDER AMOUNT}
Else
0

Ian
 
Upvote 0 Downvote
I'm am using it in the report filter so that I do not pull in any programs that have not had an incident in the last 30 days.
 
Upvote 0 Downvote
Try

not isnull({tblIncidents2003_2.Inc_date}) and {tblIncidents2003_2.Inc_date} in Aged0To30Days

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top