How to create a date filter
Posted: Tue Oct 08, 2024 2:46 pm
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
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