week_last_day(date)

Returns the date of the last day of the week for a specific date.

1q = foreach q generate week_last_day('BillDate') as "Week Last Day";