I have a customize Screen with two date picker and one GRID,
In one column of the Grid, I use "SQL Override" and access to these two date picker. The problem is, when the screen is loaded at the first time, it works. Once I change one of the date picker to different date, then refresh the grid, it shows "Error Generating Grid". However, if I change the date back to original date
, then it is ok again.
Here is my SQL code:
SELECT Count(RecordID) FROM viewIEMContainer WHERE viewIEMContainer.AssociatedItem = viewIEMReportItemAndGrossSales.ItemFullName AND viewIEMContainer.IEMTradeStatus = 'Sold' AND viewIEMContainer.IEMReceivePaymentTxnDate >'dat152406031016191919' AND viewIEMCo
ntainer.IEMReceiv ePaymentTxnDate < 'dat152406031016202020'
The question is: is it ok to access date picker from SQL? Is it correct to access those data picker by Object ID? If that is fine, what is the possible reason to cause this error generating grid error?