Format for Date argument

[Steve Workings]

{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]

Hi Steve

Have you tried '20130615' ?

[Steve Workings]

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]

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.