problem in selecting date filter.

Hi Sukhwinder,

I agree that the end date should be 23:59:59.

Can you please provide me with the following so I can ensure that I capture this problem, and ensure it's still present on the latest release of YF;

-Current build date of Yellowfin. You can get this from the info.jsp (access via appendinf info.jsp to your YF address .

e.g. http://localhost:8080/info.jsp

-Data source you are reporting against (e.g Mysql, Sql Server

-How has the date field been formatted/converted

Is this a timestamp converted to a date, via the date function? Or is this just a timestamp formatted as a date.

Thanks,

David

Hi David,

Following is the information you required:

Application DetailsCurrent Schema Version:Original Code Version:20170331Current Code Version:20170331Import Version:4.43Build Type:FULLVERSIONCurrent Session Count:0Current Session Timeout:1800 secondsApplication Server Boot Time:June 6, 2017 9:45:45 AM CESTCurrent Server Time:June 15, 2017 8:47:54 AM CEST (Europe/Berlin +0200)

Data source : Oracle

Date field is not converted/formated

Date field is just a timestamp formatted as a date

Thanks

Sukhwinder

Hi Sukwinder,

Thanks for the detailed information. I have replicated your issue and raised a task for our devs.

At this point in time, there is no ETA on this, though it's worth noting you do have a few workarounds here;

• Convert the timestamp to a date. I feel like this is your best option, as if you really do want to treate a timestamp as a date, you should convert it, as changing the format only really changes how it looks, not how it acts.
• Manually type in the time component
• Use Pre-defined date periods

Please let me know if you have further questions on this.

Regards,

David

Hi Sukwinder,

Hope you've been well. Just wanted to let you know this defect has since been fixed, actually for a little while now.

If you still have issues after updating to a 7.3 or 7.4 release in 2018, please let me know.

Regards,

David

Hi

I've upgraded to v. 8.0.5 (20200225) and when I select a custom date e.g. 2020-05-14, in the SQL statement I can see this:

- BETWEEN '2020-05-14 00:00:00.0' AND '2020-05-14 00:00:00.0

but I was expecting to see this:

- BETWEEN '2020-05-14 00:00:00.0' AND '2020-05-14 23:59:59.0

Can you check this?

Data source: PostgresQL

Date field is a Timestamp formatted as a Date Time

Thanks

Hi Stelios,

Thank you for reaching out to us on this and I apologise for any inconvenience caused. I can confirm this appears to have resurfaced and a patch is being developed as we speak. It will be included in our next release 8.0.6 which is likely due out mid-late June. I will update you on this request once this release becomes available.

Cheers,

Neal

Hi Stelios,

Hope you are well. I am just writing to let you know that 8.0.6 and 9.2 have been released which both include the fix for this issue. You can download both upgrade installers from our portal here (please note that you will need to login to access the upgrade installers).

Cheers,

Neal