I have a portal showing records based on date fields.
I have 6 portals all using the same type of relationship and one of them is not working correctly.
I have a start date and end date field that i am relating to an order date field.
My relationship is:
start date is less than or equal to order date
AND end date is greater than or equal to the order date.
This will show in the portal as all the records ordered within the 2 date fields entered.
One of my portals for some reason is not reading the year of my dates.
If i entere in 1/1/10 as start date and 1/30/10 as end date, my portal shows all records ordered in Jan 2010, Jan 2009, Jan 2008...and so on.
This is the only portal doing this and i have no idea why. I've checked that all the date fields are showing the same format of date.