Another reason not to use Date type in SalesLogix

In my previous post I logged some of my finding about Date vs. DateTime type. Here is another reason that Date type may cause problem.

In TABLE1 we have a StartDate which is a Date type. Through SLOX UI everything works fine – 00:00:00 is used as the time value when saving and SLOX knows not to do any conversion.

However there is a database view retrieving same field. It seems that SLOX doesn’t know the exact type of the field in the view so it does the UTC-to-local conversion. The result is that we get back a value which is 7/8 hours earlier.

I don’t know why SLOX provides different Date and DateTime type in table design. In SQL 2005 they are all DateTime. Maybe it saves spaces in other databases?

Advertisements
This entry was posted in SalesLogix. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s