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\2004,
fieldStr(YourTable, TimeField), 60*60*12, //12:00:00 fieldStr(YourTable, DateField), 25\08\2004);
YourTable_ds.addRange(fieldNum(YourTable, DateField)).value(_expression_);
Steeve...
-----Message d'origine-----
De : Janno Liivak [mailto:[EMAIL PROTECTED]
Envoyé : 26 août 2004 07:18
À : [EMAIL PROTECTED]
Objet : [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 only
by date (>= 25.08.2004). And then i could check on each returned row date
and time (date > 25.08.2004 && time > 12:00:00). And each row that is
returned i put in somekind of temp table and sow only a temp table on form
... or i make a list of recid's or primary key's and then i make a query of
my table with inner join on that list etc.
But isn't there a easy way? Does somebody know how to make it easier? Or
maybe somebody knows such form in Axapta where this has been already done?
Please, let me know if you do.
Axapta 3.0 SP2
MS SQL 2000 server
Thanks in advance.
Janno Liivak
[Non-text portions of this message have been removed]
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
