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

Hi! I'm in need of advice. I have a form and i want to filter data by specifying time limit... for example: show rows that are newer than 25.08.2004 12:00:00. But how can i do that when Axapta holds date and time separated (different types). Ok... i can make a query of my own and filter

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

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

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

Hi! I'm in need of advice. I have a form and i want to filter data by specifying time limit... for example: show rows that are newer than 25.08.2004 12:00:00. But how can i do that when Axapta holds date and time separated (different types). Ok... i can make a query of my own and filter data

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

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,