User selectable timeframe for printing

[Josh_Klassen]

Hello everyone,

I am having trouble with is creating a formula like the one in this sample app:

https://www.appsheet.com/samples/Reports-that-users-can-customize?appGuidString=69a02679-bfe6-45fa-8...

That is in the column Matching Items in the Report Request table:

SELECT(Data[Name], AND(IN([Size], [_THISROW].[Size Choice]), IN([Color], [_THISROW].[Color Choice])))

However instead of it using colours and sizes I want it to show all matching items that are within the dates that the user would select.

I am using two tables like is shown in the sample app. One table is called Email Timesheet and one is called Timesheet.

The email timesheet table has columns From date and To Date that the user would specify and instead of Matching items I want to have a virtual column called Selected Timesheets.

Thanks,
Josh Klassen

[MultiTech]

Try:

SELECT(Data[Key_Column], AND(
[Timesheet_Date] >= [_thisrow].[Min_Date_Selection],
[Timesheet_Date] <= [_thisrow].[Max_Date_Selection]
))