Hi ALL,
Why dont the date range work in the financial report? Is there an alternative way?
Regards,
Manjunath Dhanapal
Hi
To get a date range put double dots (..) in between the dates you want to filter.
The date range may not be working in the financial report due to a few possible reasons. It could be that the report is not configured to accept date range parameters, or that the date format used in the report parameters is different from the date format used in the system.
To troubleshoot the issue, you can try the following:
1. Check the report design and parameters: Ensure that the report is configured to accept date range parameters, and that the date format used in the report parameters matches the date format used in the system.
2. Check the data source: Verify that the data source for the report is pulling the correct data based on the selected date range.
3. Check the report filter: Make sure that there are no filters applied to the report that would prevent data within the selected date range from appearing in the report.
4. Check the system date format: Confirm that the date format used in the system matches the date format used in the report parameters.
If you are unable to resolve the issue with the date range, you can consider using an alternative approach such as creating a custom query or report that pulls data based on a specific date range. Another option could be to export the data to Excel and use Excel's filtering and sorting capabilities to analyze the data based on a specific date range.
Hi, if you mean Date Filter, this should work, you can check the standard reports.
Hope this helps.
Thanks.
ZHU
hi
can you send a screenshot?
DAniele
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156