PDA

View Full Version : Format for Date argument


ABC123

Steve Workings
06-14-2013, 11:41 PM
{grid.Object}.gridFilterSet(filterExpression [, orderExpression [, filterParameters]]) allows arguments for the filter parameters, e.g.


GRID1_GridObj.gridFilterSet('city=:whatCity' ,'Contactname','london|||c|whatCity\nuk|||c|whatcountry');


But I can't figure out the correct format of the argument to filter by date. These, for instance, do not work (using MS SQL btw):


{grid.object}.gridFilterSet('Lot_ID = :Available_Date', '', '06/15/2013|||d|Available_Date');"
{grid.object}.gridFilterSet('Lot_ID = :Available_Date', '', '2013-06-15|||d|Available_Date');"
{grid.object}.gridFilterSet('Lot_ID = :Available_Date', '', '2013-06-15|||c|Available_Date');"

Anyone know?

glenschild
06-15-2013, 06:27 AM
Hi Steve

Have you tried '20130615' ?

Steve Workings
06-15-2013, 02:03 PM
Neither one of these works Glen:


'20130615|||c|Available_Date'
'20130615|||d|Available_Date'

I can't find any examples in any of the videos, prototype code or anywhere else that show the use of a date.

Update - Wait - I had an error in my test code. This works:



'2013-06-15|||d|Available_Date'

glenschild
06-15-2013, 03:25 PM
Neither one of these works Glen:


'20130615|||c|Available_Date'
'20130615|||d|Available_Date'

I can't find any examples in any of the videos, prototype code or anywhere else that show the use of a date.

Update - Wait - I had an error in my test code. This works:



'2013-06-15|||d|Available_Date'


Glad you sorted it.