Filter date range

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am working on a report that includes a table box for Timesheets. The user wants to be able to enter a start date and end date and pull back all timesheets that cover that date range. Each timesheet itself covers a 2 week date range, closing on the 15th and last day of each month.

For example, if a user puts in Start Date = 1/5/2017 and End Date = 2/21/2017, I would need to calculate that 1/5 would fall in the timesheet with a date of 1/15 and 2/11 would fall in the timesheet with a date of 2/28. Then I need the table to filter down to the timesheets with dates of 1/15, 1/31, 2/15 and 2/28.

I have a DimDate table in my database that I can use to tie to TimesheetDate if needed.

Thanks for any help!

Re: Filter date range

Anil_Babu_Samineni — Thu, 17 Aug 2017 15:41:31 GMT

I think you need to set MonthEnd() in your set expression. Or i would offer to ask please explain realtime

topic Re: Filter date range in QlikView

Filter date range

Re: Filter date range