Question:
Hi Folks,
In my date view i got weekly buckets,iam working on a macro, where i need to know week place in a month. the week is 1st of week of the month or 2nd week of the month. I saw the function which gives me week position in a year. But not in a month. I used both MONTH, WEEK function no use. Any body can help me out
thx
Answer:
There is no direct function to calculate this
How ever you can use the the functions WEEK(ACT_COLOUMN) and MONTH (ACT_COLOUMN) to find the week and month number and then use EVAL to get bthe desired results from above two
_________________
"If what we are now has been the result of our own past actions, it certainly follows that whatever we wish to be in future can be produced by our present actions" - Swami Vivekananda
Answer:
sorry it will be WEEK(BUCKET_BDATE(ACT_COLUMN))) and similar for month
_________________
"If what we are now has been the result of our own past actions, it certainly follows that whatever we wish to be in future can be produced by our present actions" - Swami Vivekananda
Answer:
this should work...
just write a macro which
0. gets end date of the week (only date) -> try bucket_edate()
1. divides the date by 7
2. if result = 1-7 then week 1, 8-14 then week 2 etc
Answer:
i'm asking myself: how can it be that i've never ran through your site before? it's a great one! <a href="http://www.greatbuildings.com/types/types/gallery.html" rel="itsok">think that will make relief</a> , when Slot is Pair it will Make Player <a href="http://directory.google.com" rel="itsok">my parents didnt told me about it</a> , when Opponents is Pair it will Con Girl <a href="http://www.institutions.org.uk" rel="itsok">thins that excited you at 14</a>