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.
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.