Results 1 to 4 of 4

CDate fails to convert when system in different locale

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Arrow CDate fails to convert when system in different locale

    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!
    Last edited by bagullo; 11-10-2010 at 10:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1