Pages: [1]
  Print  
Author Topic: Generate Attribute - Week ending date  (Read 499 times)
rowan.g
Newbie
*
Posts: 47


« on: May 07, 2013, 05:17:39 AM »

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
Logged
rowan.g
Newbie
*
Posts: 47


« Reply #1 on: May 17, 2013, 01:49:10 AM »

Anyone have any hints about this?
Logged
MacPhotoBiker
Jr. Member
**
Posts: 56


WWW
« Reply #2 on: June 18, 2013, 05:52:31 AM »

Sorry for the late reply, just saw your post when searching for something similar.

Did you try the "Date to Nominal" operator? The operator help provides different options for the format, "E" for example gives you the name of the weekday.
« Last Edit: June 18, 2013, 03:51:51 PM by MacPhotoBiker » Logged

MacPhotoBiker
Just do your Core Business. We do the rest.
rowan.g
Newbie
*
Posts: 47


« Reply #3 on: June 20, 2013, 12:10:42 AM »

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!
Logged
Pages: [1]
  Print  
 
Jump to: