Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Oct 22, 2020 5:49 am**

Dear all,

we are using this version of your software:

: SettingsFrom.png (141.31 KiB) Viewed 2770 times

When setting the Date Time Format to "Date" only for differen datetime fields

: SettingsFrom.png (141.31 KiB) Viewed 2770 times

: SettingsFrom.png (141.31 KiB) Viewed 2770 times

the internal preview in edit mode is showing the fields properly:

: SettingsFrom.png (141.31 KiB) Viewed 2770 times

But when a report is called outside the edit mode, e.g. preview outside, the time is still shown:

: SettingsFrom.png (141.31 KiB) Viewed 2770 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!

Posted: **Mon Oct 26, 2020 7:27 am**

Hello.

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

Thank you.

Posted: **Mon Nov 09, 2020 1:06 pm**

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

Posted: **Mon Nov 09, 2020 9:01 pm**

Hello,

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

Thank you.

Creating reports and dashboards | Stimulsoft community forum

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

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

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

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

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