Simple date attribute (actually, its a Timestamp) in a grid.
Used the Column Options (the 3 dots) to filter "is after 10/1/19" . (picked October 1 2019 on popup calendar)
But the data find is for records AFTER Jan-10-2019 Here's what the logger shows and the SQL it is sending: The end user is pretty confused cause the cool new tool can't filter on dates correctly.
Did I set something up wrong?
This SQL query finds correct records:
Code: Select all
select DateCreated from RO
where DateCreated > N'10/1/2019'
My format in the attribute is MM/dd/yy hh:mm
And in the grid, no one cares about the hh:mm part, so I had overridden grid display to MM/dd/yy