400: Late, Upcoming & Current Grid Queries are Wrong (+/- 1 hour depending on timezone)
NOTE: Currently, the server determines if an item is due today or tomorrow using {getutcdate} on the database server against the item due date, which is already UTC-based.
This approach is wrong because if an item is due 3/31/2010 (12:00:00 AM) and the current time is 3/30/2010 11:00:00 PM, [getutcdate] will be 3/31/2010 3:00:00 AM.
And when you compare 3/31/2010 3:00:00 AM with 3/31/2010 12:00:00 AM, it will result in the item being due "Today."
While clearly, at 11:00:00 PM of 3/30/2010, the item due date is still 1 hour away and should considered due "Tomorrow."
Removed all {action=''"} from all .aspx forms.
NOTE: If the compiling machine has .NET 3.5 SP1 installed, it will cause the software to crash on a pure .NET 2.0 runtime server.
The reason is if the forms have a blank {action=""}, under .NET 3.5 SP1, it will auto injection the {setAction} method which does not exist on the .NET 2.0 runtime.