INLIST function

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Sherri_(Guest)
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

INLIST function

Post by Sherri_(Guest) » Thu Dec 02, 2004 5:00 pm

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

Rick_W_Johnson_(Guest)
Posts: 22
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: INLIST function

Post by Rick_W_Johnson_(Guest) » Thu Dec 02, 2004 11:23 pm

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})

Sherri_(Guest)
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: INLIST function

Post by Sherri_(Guest) » Fri Dec 03, 2004 1:26 pm

When I try entering the function as:____INRANGE(post_date{1/1/2004},{1/29/2004})____I still receive the error message :Invalid Argument

Rick_W_Johnson_(Guest)
Posts: 22
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: INLIST function

Post by Rick_W_Johnson_(Guest) » Fri Dec 03, 2004 3:47 pm

You need a comma after Post_date and before the first {

Post Reply