Page 1 of 1

Problems with date filters

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

In a new report, when I create a new variable with no default value, like this :
NewVariable.gif
NewVariable.gif (25.66 KiB) Viewed 8385 times
And I display the preview, then the date is initialized :
Preview.gif
Preview.gif (13.51 KiB) Viewed 8385 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
DateFilter.gif (24.91 KiB) Viewed 8385 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 ?


Report.mrt
(7.77 KiB) Downloaded 189 times

Thank you

Re: Problems with date filters

Posted: Tue Dec 06, 2022 9:18 am
by Lech Kulikowski
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

Re: Problems with date filters

Posted: Thu Dec 08, 2022 1:38 pm
by Lech Kulikowski
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.