Posted By: GPDJJ — 9 May 2018 at 10:13am
So I created the formula below and the use the Select Expert to select days of the week. Is there a better way to do this in an all encompassing formula rather than doing two steps? For instance like only selecting on records on a Wednesday or Thursday.
weekdayname(dayofweek({table.field}))
Posted By: DBlank — 10 May 2018 at 2:52am
maybe create a static parameter with the 7 days of the week as the description but the numeric values as 1-7
In your select expert use either datepart or dayofweek functions
{?Week Day} = dayofweek({table.date})
You can also set it to allow multiple selections
Edited by DBlank - 10 May 2018 at 2:52am
