I guess I do not understand the function StrToDateNum, as simple as the
definition seems to be.
I have a string "02/04/2007", say
Dat = "02/04/2007";
Dat1 = StrToDateNum(Dat);
I would like to find the Price on that date.
BuyPrice = ValueWhen(DateNum()==Dat1,C,1);
produces a large and incorrect value.
Can someone help me with why the above does not produce the correct value?
The Help definition for StrToDateNum has the example as "2007-Feb-04", but
my string is formatted as mm/dd/yyyy.
Would this be the reason?
Thanks,
Ken
