logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Torbenv  
#1 Posted : Friday, May 3, 2013 2:03:54 AM(UTC)
Torbenv

Rank: Member

Groups: Registered, Registered Users
Joined: 7/26/2011(UTC)
Posts: 21

In the system tester I want to add in a criteria, that a buy order must be between 20120101 and 20121231.

Therefore I have tried the following:

"ExtFml("forum.DateRange",20120101,20121231) AND ....."

"ExtFml("forum.DateRange",20120101,20121231)=1 AND ....."

But the system tester execute buy orders also outside this data range. I can not see, what I am doing wrong.

Help appreciated.

Regards,

Torben
mstt  
#2 Posted : Friday, May 3, 2013 1:54:23 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi Torben

There appears to be a bug with the DateRange function in the Forum DLL. The solution I use is the Date Filter indicator, see below.

Code:


 {Date Filter}
 {Roy Larsen, 2003-2010}

Sd:=Input("Start day" ,1,31,1);
Sm:=Input("Start month",1,12,1);
Sy:=Input("Start year" ,1980,2015,2012);
Ed:=Input("End day" ,1,31,31);
Em:=Input("End month" ,1,12,12);
Ey:=Input("End year" ,1980,2020,2012);
Start:=(DayOfMonth()>=Sd AND
Month()=Sm AND Year()=Sy) OR Year()>Sy OR
(Year()=Sy AND Month()>Sm);
End:=(DayOfMonth()<=Ed AND
Month()=Em AND Year()=Ey) OR Year()<Ey OR
(Year()=Ey AND Month()<Em);
Start AND (End OR (Start AND Alert(Start=0,2)));



Is this of any use?

Roy
Torbenv  
#3 Posted : Friday, May 3, 2013 4:41:33 PM(UTC)
Torbenv

Rank: Member

Groups: Registered, Registered Users
Joined: 7/26/2011(UTC)
Posts: 21

Hi Roy,

That is excellent. I have just tested it. I appreciate your help - again.[:)]

Regards,

Torben
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.