I am trying to convert a text date from a userform textbox into a date value for the purposes of comparison.
The textbox date is formatted as "dddd, mmmm dd, yyyy" (Monday, March 18, 2019). datetofind is defined as 'date'
Please Login or Register to view this content.
I though Cdate would do it, but it simply results in a "Type mismatch" error.
From: https://www.excelfunctions.net/vba-cdate-function.html
CDate Expression Types
The VBA Date data type holds both date and time information. Therefore the Expression that is supplied to the CDate function must be able to be interpreted as a valid VBA date or time.
The CDate function can interpret text representations of dates and times that are in a recognised Excel format. However, the function is unable to interpret dates that include the text description of the weekday (Sunday, Monday, etc).
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
So, this worked ... but I might be doing something in a more complicated manner than necessary.
Please Login or Register to view this content.
Sure, whatever works. I would have used InStr, Len, and Right. I didn't type this into VBA, but you should be able to get the idea.
dayval = CDate(Right(uf9_poststaff.processdate.Value, Len(uf9_poststaff.processdate.Value)-InStr(1,uf9_poststaff.processdate.Value," ")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks