Filtering Dates

[Prisk]

Hi,

I'm trying to write a formula that selects dates from a table but does not select any dates starting with -
25/12
26/12
31/12
01/01

I've tried using Day({date_field}) <> 1 and
month({date_field}) but this also excludes all dates starting with 1

 

[drtree]

Hi,

How about...

  IF Month({date_field}) = 12 and NOT (Day({date_field}) IN [25, 26, 31]) THEN
     FALSE
  ELSE IF Month({date_field}) = 1 AND Day({date_field}) = 1 THEN
     FALSE
  ELSE
     TRUE

Hope that helps....

doc tree