problem in selecting date filter.

sukhwinder shared this problem 3 years ago
Defect Fixed

Actually I am facing a problem,

suppose we selected a date filter DATE BETWEEN "20-05-2017" TO "25-05-2017" but in date filter it comes as

FROM DATE "20-05-2017 00:00:00"

TO DATE "25-05-2017 00:00:00".

Can we make it likes this


FROM DATE "20-05-2017 00:00:00"

TO DATE "25-05-2017 23:59:59".


In TO DATE, it should take the end of the day as "25-05-2017 23:59:59", not the start of the day

"25-05-2017 00:00:00"

Comments (7)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
2

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

photo
1

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