Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act 11 migration problem Date from uk to usa fix

Highlighted
New Member
Posts: 4
Country: United_Kingdom

Act 11 migration problem Date from uk to usa fix

Hi

I imported a db from 1 machine to another. but all the date formats are now in USA format from UK. can anyone help to fix this please

Thanks

Highlighted
Copper Super Contributor
Posts: 22
Country: India

Re: Act 11 migration problem Date from uk to usa fix

Hello Gripper,

 

Could you please let me know the version of your Act? If you have imported data from an excel, then try importing the same from a .CSV file which will import the date format as it is.

 

 

Regards,

Sandy

Highlighted
New Member
Posts: 4
Country: United_Kingdom

Re: Act 11 migration problem Date from uk to usa fix

Hi it was act 11 to a new server with act 11

Highlighted
Nickel Elite Contributor
Posts: 619
Country: USA

Re: Act 11 migration problem Date from uk to usa fix

I suggest you check the SERVER regional settings...

 

I guess this article can give you some ideas  CLICK HERE  in this case they mention that... This is fixed in Sage ACT! v14.0. (2016 or later) There is currently no workaround for Sage ACT! v13.1. (2013 or earlier)

 

 

..

...If this answered your question, please click on ACCEPT AS SOLUTION - Best regards and Good luck

 

DO NOT FORGET TO BACKUP YOUR DATABASE DAILY - and place a copy of that ZIP file in a USB memory or external disk for more security
in case your computer or server's hard drive is damaged

 

FIRMA.png

Juan Carlos Otero Garcia
juancarlosotero@protonmail.com