INLIST function
-
- Posts: 15
- Joined: Tue Oct 10, 2017 12:44 pm
INLIST function
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
-
- Posts: 22
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: INLIST function
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})
-
- Posts: 15
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: INLIST function
When I try entering the function as:____INRANGE(post_date{1/1/2004},{1/29/2004})____I still receive the error message :Invalid Argument
-
- Posts: 22
- Joined: Tue Oct 10, 2017 12:44 pm
===> RE: INLIST function
You need a comma after Post_date and before the first {