Comparing Dates in Xpath retrieve

I have a non-localized date field for a pregnancy duedate in HouseholdMember_Details inheriting from Customer_Details:   which is not localized:   I am trying to retrieve all these entries where the DueDate matches a variable I created:   but nothing seems to ever be returned. I have a household member with that duedate in the HouseholdMember_details table: but when I step through in debug mode this is being set for my created DueDate variable:   Is there a special way i should be comparing the due dates when I am only interested in the date part?
1 answers

Try addWeeksUTC for non-localized comparisons (EDIT: along with [%BeginOfCurrentDayUTC%]).