Date between filter is rounding up to next day
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?
Files:
Date Filter iss...
The same problem 
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'
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'
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
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
Hi Neal, we are using version 8.0.2
Hi Neal, we are using version 8.0.2
Hi Neal,
More info - we are using Microsoft SQL Server 2014 (SP2-CU5), and the field is a DATETIME field (not datetime2)
Regards,
Gerri
Hi Neal,
More info - we are using Microsoft SQL Server 2014 (SP2-CU5), and the field is a DATETIME field (not datetime2)
Regards,
Gerri
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:
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):
Cheers,
Neal
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:
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):
Cheers,
Neal
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
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
Hi Gerri,
Glad to hear it's all sorted. Let us know if you have any further issues.
Cheers,
Neal
Hi Gerri,
Glad to hear it's all sorted. Let us know if you have any further issues.
Cheers,
Neal
Replies have been locked on this page!