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.