Conditions with Dates

[khwaja]

I have a problem which is probably small enough for others but it has given me a lot of frustration.

I have few store records. Some of these stores have closed so these have a closure date in one column and open ones have null in this column. There is another column showing date of opening.

What I need is to be able to pick up all open stores (so I will say > Date()) in Date Open field which were not closed until 1 Jan 2002(So I will say Is null or > 30/12/01 in Date Close column). But this does not work! Any idea what operators one can be used with dates? Any solution?

Cheers

 

[AWithers]

I think your criteria should read
Is null or > #30/12/01# (or possibly) Is null or > #12/31/01# depending on how your machine is set up

the # symbols are use to delimit date strings

Hope this helps

Andy

 

[DonQuichote]

Actually, the # signs denote a date literal. Date literals are always in american format, so they are independent of how your machine was set up.