0

Date Range Filter in nl

Jet Reports Historic Posts

October 23, 2009 22:15

None

Follow

I am writing query which will give me results based on fact that the date field should not have date range that user adds.
For example if user adds range between 1/1/2009..1/31/2009, all the records that donot contain date field between this range should show in report. The date field can be empty and those record should also be added.

I need some thing like <>1/1/2009..1/31/2009

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts October 24, 2009 18:46

  What about splitting the filter into 2 separate filters based on the same field?
  The first should be '..1/1/2009' and the second '1/31/2009..'
  
  Just thinking out loud ;)
  
  rmw

• 0
  
  Jet Reports Historic Posts October 26, 2009 08:29

  D3 = Start Date (1-1-2009)
  D4 = End Date (31-1-2009)
  
  NP("DateFilter",,D3 - 1) & "&" & NP("DateFilter",D4 + 1)