week_last_day(date)

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

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