ACT! v11.1.183.0 Hotfix1 incorrectly converts Character to Date fields

[DickDern]

All dates in all Character fields that I try to convert to Date are incorrectly converted to one day previous. For example, 10/16/07 (Character) converts to 10/15/2007 (Date). Is this a known bug? I am using Tools > Define Fields > Edit Field. Change Character to Date. Thanks.

[ghollister]

I tested this in 11.1 (using the same date in your example) and was not able to duplicate what you are experiencing, so it does not appear to be an issue with software. Try an alternative method:

- Create a new date field and add it to your layout

- Go to Edit/Copy Field

- Copy the data from your current character field to your new date field

- Remove the old character field from your layout

Additional suggestions:

- Go to Tools/Database Maintenance/Check & Repair....do this twice in a row

- Make sure your Windows time and date settings are correct on your machine (from the Date & Time and Regional/Language Options settings in the Control Panel)

Message Edited by ghollister on 05-12-2009 12:13 PM

[DickDern]

Sorry. This porblem is database-specific. I cannot reproduce in ACT11Demo.