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(Table, Field), systemDateGet(),fieldStr(Table, Field), timeNow())); Best regards Erik Hanse

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=EISNewsArticleMenuFunctionType=OutputNEWSID=351 You can do that : Str _expression_ = strfmt%1 == %2) (%3 = %4)) || (%5 %6)), fieldStr(YourTable, DateField), 25\08\2004, fieldStr(YourTable,