Hi,
I have dates in a string in excel which are formatted like "dd.mm.yyyy"
I don't manage to get VBA to recognize the date, I get the error 13 "Type mismatch" on the line ConvertToDate = CDate(x(1))
Example: in the following code x(1) = 06.07.2020
I assume I try to make the string look like a date in the wrong way?
Please Login or Register to view this content.
Your help would be appreciated!
Last edited by Solvax; 11-07-2020 at 06:20 PM.
Try:=
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Try the red highlighted line of code this way...
Please Login or Register to view this content.
Last edited by Rick Rothstein; 11-07-2020 at 08:41 PM.
Thank you guys for the solutions. Both worked!Kudos to you!
Just so I know for the future... I am guessing the order for your locale's dates is day month year. If so, did my method and mehmetcik's method produce the same date for you? I don't do international programming, so I am not sure, but my understanding is that VBA works with US locale date ordering (month day year) so I assumed simply replacing the dots with slashes would not produce the correct date for you. So I am asking... is your locale's date ordering day month year and, if so, did mehmetcik's suggestion give you the correct date?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks