Date between filter is rounding up to next day

Gerri shared this problem 13 days ago
Resolved

aWhen we have a date filter that is selecting a range of dates, the value in the SQL statement for the TO date has a time portion of 23:59:59.999. However in SQL this rounds up to the next day. Is there a setting in Yellowfin to ensure that the time value can be set to 23:59:59.997?

Comments (7)

photo
1

NNoting that this is not an issue in an older version of YF (7.1) which sets the time correctly: BETWEEN '20190810 00:00:00.0' AND '20190910 23:59:59.997'

photo
1

Hi Gerri,


I have been unable to replicate this yet, but I will keep looking into it. Can you please confirm which version of Yellowfin you are on? This article will guide you to the correct version if you are unsure


Cheers,

Neal

photo
1

Hi Neal, we are using version 8.0.2

photo
1

Hi Neal,


More info - we are using Microsoft SQL Server 2014 (SP2-CU5), and the field is a DATETIME field (not datetime2)


Regards,

Gerri

photo
1

Hi Gerri,


Thank you for confirming those. I am still unable to replicate your issue with the data I have available, my SQL is being reported as the following:

46488000b1db40271d1b08f6d2854529My DateTime field is set as a datetime (not datetime2).

aae5202fa33e702dded88c736f6356da


Would you please send through a screen shot of the diver your connection is using? To get this, please go to:

Administration->Admin Console->Data Sources->[your data source]

and then expand Connection Settings, scroll down and click on Test Connection. After you have done this, please take a screen shot of the details that appear (see mine below):


21ed53a6d6659effa99e89e399303712

Cheers,

Neal

photo
1

Hi Neal, thank you so much for that information!! We had the wrong driver selected - azure database instead of ms sql server (it was originally an azure db but that ran too slow).

Really appreciate your help

Regards,

Gerri

photo
1

Hi Gerri,


Glad to hear it's all sorted. Let us know if you have any further issues.


Cheers,

Neal