problem in selecting date filter.

sukhwinder shared this problem 2 weeks ago
Defect Logged

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 (3)

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