Hi, We are working on some important location tracking and inventory reports for the PAHMA deployment, and I wanted to check in and see if anyone has written SQL or a report that will show for example, all the objects currently in a given location. The complication is that objects can have multiple location/movement/inventory records, so you have to get the one with the most recent movement_common.locationdate value. And while I'm at it, I am once again confused by the date values constructed by the calendar date widget. On the movement_common.locationdate field, if I type in "1/1/2012" the UI shows "2012-06-01T00:00:00Z". When I select that value from the database, it reads "2011-12-31 16:00:00". I understand we're trying to create a global-ready system, but this can't be what we mean. The value in the database is in the previous year. Have we configured something wrong here on a local server? Thanks in advance, Chris