"Generate Attribute - Week ending date"
Hi,
I'm trying to generate a week ending date - assume the week ends on a Sunday.
For example - if the date is 7/05/2013, week ending date falls on 12/05/2013.
I'm trying to generate it using a formula within Generate Attribute but it's proving difficult to convert a date to a day of the week.
Any ideas on how to solve this?
Thanks again!
Cheers,
Rowan
I'm trying to generate a week ending date - assume the week ends on a Sunday.
For example - if the date is 7/05/2013, week ending date falls on 12/05/2013.
I'm trying to generate it using a formula within Generate Attribute but it's proving difficult to convert a date to a day of the week.
Any ideas on how to solve this?
Thanks again!
Cheers,
Rowan
Find more posts tagged with
Sort by:
1 - 3 of
31
Anyone have any hints about this?
I found this blog recently that had an excellent solution http://rapidminernotes.blogspot.com.au/2013/05/finding-next-sunday.html
I tried it and it worked - gave me a bit more of an understanding about how some of these rapidminer functions work.
In the end I wrote an SQL query on my "Read Database" operator because my process was already too long without the addition of more operators.
I'll play with date-to-nominal today and see what happens.
Thanks for replying!
I tried it and it worked - gave me a bit more of an understanding about how some of these rapidminer functions work.
In the end I wrote an SQL query on my "Read Database" operator because my process was already too long without the addition of more operators.
I'll play with date-to-nominal today and see what happens.
Thanks for replying!