Community
Showing results for 
Search instead for 
Do you mean 
Reply

Confused as to why Group results are as they are

Astute Commentator
Posts: 77
Country: USA

Confused as to why Group results are as they are

I am completely baffled on this one:

 

I have a Group set up for Dynamic memers:

Field > info pulled on or After > 8/23/2010 and

Field > info pulled on or before > 8/29/2010

 

When the field info pulled = 8/24/2010 the contact is a member of the group (as I would expect) , but when it is 8/23/2010 it is not. My computer's date is 8/24/2010 and I am using ACT! by Sage 2010 Version 12.1.181.0, Hot Fix 1

 

Anyone have any ideas as to why this might be happening?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Confused as to why Group results are as they are

Same field?
Date field(s)?

If you change the top one to "Equal To", does it find 23rd?

As a workaround, you might try just changing the date to 22nd... I think date fields still include (internally) a time as well and this might be throwing it out in the query.