Hello
In a new report, when I create a new variable with no default value, like this :
And I display the preview, then the date is initialized :
How can I make it not initialized (empty date, with no date selected) when the report is displayed ?
I also have another problem : when I add a date filter with a value (no variable), like this :
Then I see no result in the preview even if the filter should return data. How can I have data with this date filter ?
Thank you
Problems with date filters
-
- Posts: 6832
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problems with date filters
Hello,
1. You can set the "Not Assigned" option for the nullable datetime type.
2. We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#9299
1. You can set the "Not Assigned" option for the nullable datetime type.
2. We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#9299
-
- Posts: 6832
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problems with date filters
Hello,
The issue with types DateTime and DaetTimeOffset. Please try to use the following Expression in the Filter:
Summary_of_Sales_by_Quarters.ShippedDate > new DateTimeOffset(new DateTime(1994, 1, 1))
Thank you.
The issue with types DateTime and DaetTimeOffset. Please try to use the following Expression in the Filter:
Summary_of_Sales_by_Quarters.ShippedDate > new DateTimeOffset(new DateTime(1994, 1, 1))
Thank you.