1. Chuck Weger
  2. Report Editor
  3. Freitag, Juni 09 2017, 12:41 PM
  4.  Abonnieren via E-Mail
Brand new user here, hoping I'm just doing something dumb. Using Valentina Studio 7.2 on MacOS 10.11.6 to connect to MS SQL Server 2014. Trying to do a very simple report on a table that contains (among other fields) a DATETIME field and a DATE field.

The DATE field formats correctly on the report, but the DATETIME field shows garbage like "00/19/-2240 00:00:00:000" for a default format, and "12/19/42 12:00 AM" for DateShort formats.

What am I doing wrong? Is there some other setting I need to adjust for DATETIME fields?

Thanks!
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Chuck,

I can see the same issue, so most probably we have to fix it.
As a workaround, you can convert DATETIME field to string in your query (if you need to get this report right now).
Referenzen
  1. http://valentina-db.com/bt/view.php?id=7985
Kommentar
There are no comments made yet.
Chuck Weger Akzeptierte Antwort
Thank you, I'll do that workaround for now.
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
This is an awesome reason to use VDB instead of MSSQL (Sorry, couldn't resist...)

My team had a similar problem with MSSQL and eventually had to change the datatype to a time stamp using epoch time in seconds. Then we just formatted the result via format function.


FORMAT(datefield, 'YYYY-MM-dd hh:mm:ss', 'kDateFormat_Pattern')....


Worked after that.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
DATETIME type
processing fix will be available in the version 7.2.1
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories