1. Chuck Weger
  2. Report Editor
  3. Friday, June 09 2017, 12:41 PM
  4.  Subscribe via email
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!
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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).
References
  1. http://valentina-db.com/bt/view.php?id=7985
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Chuck Weger Accepted Answer
Thank you, I'll do that workaround for now.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Scott Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
DATETIME type
processing fix will be available in the version 7.2.1
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
  • Page :
  • 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