We have a set of data with multiple rows, with one column being a date. We are wanting to allow the user to select a date (date picker User Input Control is fine), then display two tables of data as a result: one table containing records that match the selected date, and the second table displaying records that match the whole week the selected date is in.
I had assumed I could take the chosen date and store this as Selected_date, then from this calculate the date that is the end of the week to use as a limit in my second table: for example DATE_ENDOF($Hours_worked_date,week,0,Monday)
I can calculate that date OK, but how do I store this as a variable? I thought using SET, but no joy. Hopefully just a syntax issue. Thanks heaps for looking.