Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert text to date

Status
Not open for further replies.
vzachin

vzachin

Technical User
Feb 10, 2006
305
0
0
US
hi,

i need help converting a text string to a date and then comparing that date to today's date.

the text string is formated as mmddyy eg:122209

thanks
zach
 
Sort by date Sort by votes


zach,

Check out DateSerial function...
Code: 
dim MyDate as date

MyDate = DateSerial(Cint("20" & Mid("122209",5,2)),CINt(Mid("122209",1,2)),CInt(Mid("122209",3,2)))


Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
thanks skip. i was looking the dateserial but wasn't sure how it worked

zach
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

guy cothal
  • Locked
  • Question
deselect text
Replies
0
Views
42
guy cothal
guy cothal
Remyaram
  • Locked
  • Question
VB6 to open extra sessions
Replies
11
Views
87
Remyaram
Remyaram
bklabel1
  • Locked
  • Question
VBA to OpenVMS and I'm lost 1
Replies
5
Views
75
SkipVought
S
nyrtfleury14
  • Locked
  • Question
Attachmate Extra macro moving to Reflection
Replies
1
Views
66
SkipVought
S
Vik12
  • Locked
  • Question
VBA causing excel to freeze
Replies
15
Views
114
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top