MS doesn't have Date. It does have Month, Day of Month, and Year functions.
From the Help file:
SYNTAX month()
FUNCTION Plots the month of the year for the price. If a bar was plotted on 10/15/96, "10" would be plotted.
To get the month of an event (Again from the Help file:
SYNTAX
valuewhen ( Nth, _expression_, DATA ARRAY )
For the most recent event's Month:
valuewhen( 1, MyEvent, Month() )
I think the above is accurate. I've gotten a bit rusty.
Why do you want the date format you are showing?
Ron
--- In
equismetastock@ yahoogroups. com, hitendra@xxx wrote:
>
> I want cross over date
>
> Simple example
>
> Cross over date of price over 10 day average
>
> We
can get the price with value when function
>
> How about date in format of mm/dd/yy
> Sent on my BlackBerry® from Vodafone
>