Date Time Format still showing "Time" although set only to "Date"

Stimulsoft Dashboards.WEB discussion
Post Reply
FGa
Posts: 5
Joined: Tue Jul 14, 2020 2:11 pm

Date Time Format still showing "Time" although set only to "Date"

Post by FGa »

Dear all,

we are using this version of your software:
SettingsFrom.png
SettingsFrom.png (141.31 KiB) Viewed 2134 times
When setting the Date Time Format to "Date" only for differen datetime fields
SettingsFrom.png
SettingsFrom.png (141.31 KiB) Viewed 2134 times
SettingsFrom.png
SettingsFrom.png (141.31 KiB) Viewed 2134 times
the internal preview in edit mode is showing the fields properly:
SettingsFrom.png
SettingsFrom.png (141.31 KiB) Viewed 2134 times
But when a report is called outside the edit mode, e.g. preview outside, the time is still shown:
SettingsFrom.png
SettingsFrom.png (141.31 KiB) Viewed 2134 times
We use the following SQL filter to convert the field:

Code: Select all

CreationTime >= CONVERT(DATETIME,'{varDateFrom}',{dateConvertNumber}) AND CreationTime < CONVERT(DATETIME,'{varDateTo}',{dateConvertNumber})
We have different customers using our software complaining about this.

Any idea/suggestion how to solve it? I couldn't find any helpful post here sofar.
Thanks in advance for your help!
Attachments
SoftwareVersion.png
SoftwareVersion.png (16.35 KiB) Viewed 2133 times
PreviewOutsideEdit.png
PreviewOutsideEdit.png (73.08 KiB) Viewed 2133 times
PreviewInsideEdit.png
PreviewInsideEdit.png (82.37 KiB) Viewed 2133 times
SettingsTo.png
SettingsTo.png (123.28 KiB) Viewed 2133 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Date Time Format still showing "Time" although set only to "Date"

Post by HighAley »

Hello.

the issue is already solved.
Please, update to the latest build.

Thank you.
FGa
Posts: 5
Joined: Tue Jul 14, 2020 2:11 pm

Re: Date Time Format still showing "Time" although set only to "Date"

Post by FGa »

Hi,

we updated to the version 2020.5.1 from 29.10.2020.

The problem we were encountering is still existing and now we have also problems with the SQL filter we used to apply to convert the field datetime, that was working properly before the update:

CreationTime >= CONVERT(DATETIME,'{varDateFrom}',{dateConvertNumber}) AND CreationTime < CONVERT(DATETIME,'{varDateTo}',{dateConvertNumber})

Can you check once again if the problem was really solved? There is still a difference between the preview in edit mode and the report itself.

Thanks in advance!
Francesca
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Date Time Format still showing "Time" although set only to "Date"

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Post Reply