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
________________________________
From: jannolii [mailto:[EMAIL PROTECTED]
Sent: 26. august 2004 13:29
To: [EMAIL PROTECTED]
Subject: [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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129hs8fvu/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1093676222/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=950169991>
________________________________
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]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| 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.
