Can I convert a field in the SalesLogix account table from being a Date/Time field to being a Date field?

Question:

Can I  convert a field in the SalesLogix account table from being a Date/Time field to being a Date field?

Can I just issue an “Execute SQL” from the Administrator and send to remotes? Assuming that is ok, what tables to I have to update? The first one that comes to mind is the SECTABLEDEF; and I’d have to change the DATETIMETYPE from “U” to “D“. Are there any others?

It looks like the field definition in SQL itself is the same for both date and date/time so I won’t have to change it there.

Answer:

In the (SQL) db it is always a datetime field. It is how SalesLogix uses it and how the provider looks at it. Sectabledefs controls this.

Correct.. just use ExecuteSQL in the admin and send to ALL remotes as well (using ‘U’). Nothing else needs to be touched.