Page 1 of 1

How to create a date filter

Posted: Tue Oct 08, 2024 2:46 pm
by brightsg
Hi
WE are using the PHP version but building reports in the desktop designer.
I have created a variable to collect a date range from the user
Name = DateRange
Alias = Date Range
Type = dateonly > Range
Int by = Value
From = [todays date] > Not assigned = unchecked
To = [todays date] > Not assigned = unchecked
Read Only = unchecked
Request from user = checked
Remember selection = checked

When I 'ok' and run the report it shows a single input (not a date selector) with todays date, if i go back in to edit the variable it has changed

Name = DateRange
Alias = Date Range
Type = dateonly > value
Int by = Value
Value = [Todays date] > Not assigned = unchecked
To = missing
Read Only = unchecked
Request from user = checked
Remember selection = checked

Can someone advise what I am doing wrong or provide a sample report? I can't find one in the samples on line.

Thanks

Re: How to create a date filter

Posted: Tue Oct 08, 2024 8:05 pm
by Lech Kulikowski
Hello,

Please check the sample report.

Thank you.