Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

Copper Contributor
Posts: 23
Country: United States

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

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.

Platinum Elite Contributor
Posts: 6,537
Country: USA

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

[ Edited ]

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

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 23
Country: United States

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

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