Page 1 of 1
INLIST function
Posted: Thu Dec 02, 2004 5:00 pm
by Sherri_(Guest)
Can the inlist function work with dates? If so, how do you enter?____This is how I was doing it, and I was getting an invalid argument error message:____INLIST(post_date,01/01/2004,01/29/2004)____post_date is a field in the database.____I^m I entering it wrong? Or does this function just not work with dates? If not, is there any other function that does??____Thanks
=> RE: INLIST function
Posted: Thu Dec 02, 2004 11:23 pm
by Rick_W_Johnson_(Guest)
I did not spend a lot of time on it, but I think if you use braces around the dates, it will work since the braces tell the variable it is a date. __inlist(post_date,{01/01/2004},{02/29/2004})
==> RE: INLIST function
Posted: Fri Dec 03, 2004 1:26 pm
by Sherri_(Guest)
When I try entering the function as:____INRANGE(post_date{1/1/2004},{1/29/2004})____I still receive the error message :Invalid Argument
===> RE: INLIST function
Posted: Fri Dec 03, 2004 3:47 pm
by Rick_W_Johnson_(Guest)
You need a comma after Post_date and before the first {