Check the default setting on db and change to var On May 30, 2017 13:42, "nadhir mohamed via skunkworks" < skunkworks@lists.my.co.ke> wrote:

there is an excel file with VBA macros that is accessing data from the server, Now it works on some workstations and generating the following error on certain PC "error 1004 error converting data type varchar to datetime"

I checked the date formats and everything is ok anyone with an idea

_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------

Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke