08-17-2010 05:08 PM - edited 08-17-2010 05:17 PM
I am using the Act.Framework.DateFilterCriteria to filter out contacts my modification date. However, it will only filter the contacts using the MM/DD/YYYY and it ignores the HH:mm:ss, even though the hour and minutes are part of the date.
For example, if I create the filter using a start date of 08/17/2010 03:10:20 PM , it ignores the 03:10:20 PM piece and only filters from the 08/17/2010 onward. Is there another filter that I can use to do filtering by date AND time of day?
dStartFilter = "8/18/2010 6:36:50 PM"
dEndFilter = "1/1/9998 12:00:00 PM"
aFilter() = new Act.Framework.DateFilterCriteria(cfd1, dStartFilter, dEndFilter) ' this is a shortcut
The result is:
"TBL_CONTACT.EDITDATE >= '2010-08-18T05:00:00' AND TBL_CONTACT.EDITDATE < '9998-01-02T05:59:59'"
The resulting date is definitely incorrect. So how does the date filter work properly?
Is there a way of creating a clause and embedd it into the filter thus bypassing the DateFilterCriteria bug?
Thank you in advance.
08-17-2010 05:51 PM
I just created my own date filtering class that created a string:
"TBL_CONTACT.EDITDATE >= '2010-08-17 19:09:38' AND TBL_CONTACT.EDITDATE < '9998-01-01 12:00:00'"
And contacts that were edited at 2010-08-17 5:12:00 PM were picked up. The contact should have been filtered out. Hence, there is nothing wrong with the Act.framework.DateFilterCriteria class, but there is something suspicious going on with the execution of the filter on Contacts.
Sorry, I'm starting to use all the filtering mechanisms in ACT! and I am getting results that are unexpected.
Any light on this would be very helpful.
08-18-2010 12:10 PM
The data filter in ACT! for the EDITDATE field ignores the Hour, minutes and seconds setting. Any workaround on this???