Help again please! I have a field with dates in it (01/01/1976) and wish to either select all records that are blank or exclude all records that have date in them. I have tried "Exclude > 01/01/1900" and also "Exclude 01/01/1900:01/01/2300" but neither works, grateful for help please.
Thak you for that, I had looked in the help menu and had tried that macro, however, when I run it it comes up with the error: Wrong number of arguments or invalid property assignment 'Exclude' (Position in macro line 1 character 1). I have typed in the macro exactly as you typed it above, ie no quotation marks etc. Grateful for any further help
For Mary Doyle: I have tried your macro I put Exclude "DT","01/01/1900" & "01/01/2300" - which ought to exclude any date between 1900 and 2300(?) but got the error: "Command failed. The parameter is incorrect (80070057) Position in macro line 1 character 1"
Not sure what I am doing wrong?
Good to be reminded that Exclude "DT","01/01/1900:01/01/2300" works. I vaguely seemed to remember that sometime in the far distant past I needed to separate the 2 dates with &. May have been the previous Cardbox macro language. Retirement must have dulled my brain!
"DT","1/1/2001" & ":" & "31/12/2001", is obviously unnecessarily cumbersome but it would have worked if you had copied it correctly. You only included & not & ":" &. Anyway, it was only intended as an example in case you needed it in the future and not relevant to the query you posted.
As always, Bert's solution Exclude "DT",":" is simplicity itself in solving that.
My very best wishes to all for a happy Christmas and good programming in 2014!