Solved: Create a form to select rows between 2 dates - Page 2

Tritonos_Gruppe · 10-18-2019 01:21 AM

Hi, I would like to create an form page in my app that alows user to select “From Date” to “To Date” and find all rows in between those dates. Then I want to create an report. I got most down except expression to select rows between to dates. Hope someone could help me in the right direction.

Suvrutt_Gurjar

Hi @Tritonos_Gruppen

Is your data from where you wish to select the rows in different table than the table where your form is based on?

Ifyou are building the app exactly like the sample app, then you could use an expression something like
below for the VC [Matching Items] as in sample app

SELECT(Yout Data Table Name [Key Name of Data Table], AND([Date in Data Table] >=[_THISROW].[From Date], [Date in Data Table] <=[_THISROW].[To Date]))

View solution in original post