Page 1 of 1

Problems with date filters

Posted: Tue Dec 06, 2022 8:48 am
by Yannick

In a new report, when I create a new variable with no default value, like this :
NewVariable.gif (25.66 KiB) Viewed 155 times
And I display the preview, then the date is initialized :
Preview.gif (13.51 KiB) Viewed 155 times
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 :
DateFilter.gif (24.91 KiB) Viewed 155 times
Then I see no result in the preview even if the filter should return data. How can I have data with this date filter ?

(7.77 KiB) Downloaded 22 times

Thank you

Re: Problems with date filters

Posted: Tue Dec 06, 2022 9:18 am
by Lech Kulikowski

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.

Re: Problems with date filters

Posted: Thu Dec 08, 2022 1:38 pm
by Lech Kulikowski

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.