I've done some research and I have not found any solution so I am positing it here to see if it is REALLY impossible before I give up
I have a macro that reads some cells coming in a "dd mmm yyyy" format as a string, where mmm are the three-letter abreviation in ENGLISH. To read it I replace spaces as hyphons and use CDate. No problem here, since I set my system with english formats.
however when run from a spanish locale computer Cdate fails to convert it to date.![]()
is there any function that can do the trick?
the macro involves numerous date comparisons, so better if it is something simple
thanks!![]()
Bookmarks