Date filter without time element

Craig Hazell shared this question 3 months ago
Answered

Hi,

I have a date field in a view and I'm looking to add a filter based on this in a report. When I run the report, the filter always chooses the current time which is not suitable, I need it to not filter based on the time or to default to 00:00:00.

The date field is purely a date e.g. convert(date,field) and so there is no time element.

Is this possible?

Comments (8)

photo
1

Hi Craig,


Thanks for reaching out with your issue.


I'm trying to recreate your situation on our side, so far I've been able to successfully define a date filter value in a report using Filter Formatting options: dabb573939aa31c865741832c43cafe4


This filter is applied as defined when I run the report. The timestamp below the title is the time at which the report is run:21e9fd4bd5cd039f6f93ba8982e77afa


One thing of note - there is no time reference at all in my filter - 00ca31627273d90b1376bb9c190c9e38


Could you help me attempt to replicate this issue by providing some additional information -


-screenshots of the behavior

-screenshots of the filter's configuration

-sql statement of the report


Thanks,Eric

photo
1

Hi Craig,

Just wanted to check in as I have not heard from you in some time. Were you still interested in support on this issue?

Thanks,

Eric

photo
1

Hi Eric,

Yes I would still like some help with this please.

I will gather the information you have asked for and get back to you

photo
1

Hi Craig,

Replying for Eric as he's out the remainder of the week.

Thanks for the update, we look forward to your reply.

- Ryan

photo
1

Please find attached a screenshot showing the filter behavior, a screenshot showing the filter configuration, the SQL as displayed in the report designer, and the SQL used to create the view.

photo
1

Hi Craig,

Thanks for your reply. Based on the image supplied, this is a version 7.2 or older instance of Yellowfin that is exhibiting this issue. As we have made significant changes to the Date Picker function in subsequent versions, you may not be able to achieve desired results through your current build. Furthermore, as this version has reached End-of-Life, it is no longer officially supported.


Would you be in a place to test this functionality by way of an upgraded instance? As always we encourage due diligence and reviewing our Best Practices page prior to an upgrade -


https://community.yellowfinbi.com/knowledge-base/article/%E2%80%8Bbest-practice-for-performing-a-yellowfin-upgrade

Thanks,

Eric

photo
1

Thank you, that has now resolved the problem. Please close the case.

photo
1

Thanks, Craig, I will mark this ticket as Answered. Feel welcome to reach out with issues in the future.

Thanks,

Eric