|
PureBytes Links
Trading Reference Links
|
Thanks
Lionel
<SPAN
class=014454408-03052001>
Never
spotted the INT() function - does not work sadly but it did give me some hope
for a short while.
<SPAN
class=014454408-03052001>
<SPAN
class=014454408-03052001>Concatenating the year from 2001 to 01, for
example, does not work either as it is not millennium friendly. 1999, 2000
& 2001 would order incorrectly.
<SPAN
class=014454408-03052001>
I can
normally design a work around solution for challenges stemming from MS's
idiosyncrasies but this one really has me stumped. I alerted technical
support yesterday and I am sure they are reading this list, so I shall
keep you informed on their response.
<SPAN
class=014454408-03052001>
As
always,
<SPAN
class=014454408-03052001>
<SPAN
class=014454408-03052001>Steve
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Lionel IssenSent: 03 May 2001 02:24To:
metastock@xxxxxxxxxxxxxCc: support@xxxxxxxxxSubject: Re:
Current Day!
page 250 of V7.xx defines an integer
function. Perhaps defining each number as an integer would
help
Try something like this:
DOM:= integer(DayOfMonth());
MON:= integer(Month());
YR:=Integer(Year());
Let me know if it works or
not.
Lionel Issen<A
href="mailto:lissen@xxxxxxxxx";>lissen@xxxxxxxxx
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
neo
To: <A title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Wednesday, May 02, 2001 4:22
PM
Subject: RE: Current Day!
<FONT face=Arial color=#008080
size=4>Perhaps you could combine the 2 with and If
function?
<FONT face=Arial color=#008080
size=4>
<FONT face=Arial color=#008080
size=4>neo
<FONT face=Tahoma
size=2>-----Original Message-----From: <A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of
C.S.Sent: Wednesday, May 02, 2001 3:39 PMTo: <A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxxSubject:
Re: Current Day!
I tried the equation backwards to see if DDMMYYYY would
work.
<FONT
size=2>DOM:=DayOfMonth();MON:=Month();YR:=Year();YR+(MON*10000)+(DOM*1000000)
It works for the first day but not for the days at the
end of the month.
for 4/30/2001 I get 30042000 and not
30042001.
-Corey
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Steve
Brann
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Wednesday, May 02, 2001 9:36
AM
Subject: RE: Current Day!
<FONT face=Arial color=#0000ff
size=2>Hi L
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Thanks. Version 7.02 end of day version.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>I am also getting results such as 20001032 (Oct 32nd,
2000) when I should be getting 20001101 (Nov 1st,2000).
Interesting eh?
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Steve
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<FONT face=Tahoma
size=2>-----Original Message-----From: <A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>owner-metastock@xxxxxxxxxxxxx
[<A
href="mailto:owner-metastock@xxxxxxxxxxxxx";>mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Lionel IssenSent: 02 May 2001
14:52To: metastock@xxxxxxxxxxxxxSubject: Re:
Current Day!
Steve:
This is an excellent concise
method.
What version are you using?
Lionel Issen<A
href="mailto:lissen@xxxxxxxxx";>lissen@xxxxxxxxx
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Steve
Brann
To: <A
title=metastock@xxxxxxxxxxxxx
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx
Sent: Wednesday, May 02, 2001
7:05 AM
Subject: Current Day!
<FONT face=Arial
size=2>Hi
<FONT face=Arial
size=2>
I use
the following in my explorations to denote the date of the last
price data in the format yyyymmdd;
<FONT face=Arial
size=2>
<FONT face=Arial
size=2>DayOfMonth()+(Month()*100)+(Year()*10000)
<FONT face=Arial
size=2>
However,
this fails if the date is the first of the month such as March 1st
2001, instead of getting 20010301 I get
20010300!
<FONT face=Arial
size=2>
Has
anyone else experienced this and if so is there a solution? By
the way, using <FONT face=Arial
size=2>DayOfMonth() on its own produces
01.
<SPAN
class=632160112-02052001>
<SPAN
class=632160112-02052001>Thanks in
advance
<SPAN
class=632160112-02052001>
<SPAN
class=632160112-02052001>Steve
|