Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 6/3/2010(UTC)
Posts: 2
|
Hi
I am using Explorer to give me the close of each Thursday for the past month of May.
How do I get it to select a Thursday in a particular month?
Col A 26 May
Col B 19 May
Col C 12 May
Col D 5 May
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 6/3/2010(UTC)
Posts: 2
|
As an indicator I have this below but it does not allow me to specify one Thursday eg. 26 May
CLOSE AND DayOfWeek() = 4 AND Month() = 5
I want to now take this and put it into Explorer once I have figured out how to specify a date?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Add "DayOfMonth()" and "Year()" to your code, and put it in the FILTER tab of an Exploration. You won't need "DayOfWeek()" for your purpose.
|
|
|
|
|
|
| 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.
