RE: [development-axapta] how to filter data on forms (date and time fields)...

2004-08-27 Thread Erik Hansen
Hi Janno, In a queryRange you have a possibility to write an argument in the value. QueryBuildRange.value(strfmt('((%1 >= "%2") && (%3 >= "%3"))', fieldStr(, ), systemDateGet(),fieldStr(, ), timeNow())); Best regards Erik Hanse From: jannolii [

RE : [development-axapta] how to filter data on forms (date and time fields)...

2004-08-26 Thread Steeve Gilbert
Check this article on TechNet : http://technet.navision.com/default.asp?MenuFunctionName=EISNewsArticle&MenuFunctionType=Output&NEWSID=351 You can do that : Str _expression_ = strfmt("(((%1 == %2) && (%3 >= %4)) || (%5 > %6))",     fieldStr(YourTable, DateField), 25\08\200