Report for Mondays only 1

[Jazztpt]

I am very much a beginner but need to build a report that looks at data for a partricular day, i.e. use a parameter to choose a day, say Mondays and then a date range. Not sure how to marry the dates up with the day of the week, can format the dates so the day is shown but stuck on how to use that for my parameter .Any help would be much appreciated.
Jazztpt

 

[lbass]

Let's say you have two parameters set up: {?dayofweek} with options set up with a value (1,2,3,etc.) and a description ("Sundays","Mondays", "Tuesdays", etc.). You can choose to display the description for the users, while using the value in your record selection formula, as in:

dayofweek({table.date}) = {?dayofweek} and
{table.date} in {?daterange}

For a faster report, you could create a SQL expression for the dayofweek {%dayofweek}:

{fn DAYOFWEEK(table.`date`)}

...and then use a record selection formula of:

{%dayofweek} = {?dayofweek} and
{table.date} in {?daterange}

-LB