Showing results for 
Search instead for 
Do you mean 

Look up a date range

New Member
Posts: 1
Country: australia

Look up a date range

I want to look up a date range in a User field ie the field is a date and I want to be able to look up all the records that in June ?
Posts: 4,395
Country: USA

Re: Look up a date range

Hello Mario,


Which version of ACT! are you using (Help | About ACT!)?


Is the user field an actual date field where you can select from a mini calendar? Or a character field, where you have to type in the dates?


If its a date field, you can do an advanced query and use the 'On or After' and 'On or Before' operators.