Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/27/2014(UTC)
Posts: 3
|
Hi,
how i can find the highest value between two dates?
for example find highest value between 2013/01/01 and 2013/10/10
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Try something like:
[code]
sDay:=1;
sMonth:=1;
sYear:=2013;
nDay:=10;
nMonth:=10;
nYear:=2013;
start:=Year()>sYear OR (Year()=sYear AND (Month()>sMonth OR Month()=sMonth AND DayOfMonth()>=sDay));
end:=Year()<nYear OR (Year()=nYear AND (Month()<nMonth OR Month()=nMonth AND DayOfMonth()<=nDay));
{plot}
ValueWhen(1,end,HighestSince(1,start,H));
*/code
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 3/27/2014(UTC)
Posts: 3
|
I want to find pivot points between two dates, then i must find 3 point, for exmaple : MaxPoint:=***; MinPoint:=***; ClosePoint:=***;
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Well have a go at writing it yourself; if you get stuck then ask for more help, and post your code.
|
|
|
|
|
|
| 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.
