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 Mike Lewis 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
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
115
guy cothal
guy cothal
Remyaram
  • Locked
  • Question
VB6 to open extra sessions
Replies
11
Views
280
Remyaram
Remyaram
bklabel1
  • Locked
  • Question
VBA to OpenVMS and I'm lost 1
Replies
5
Views
173
SkipVought
S
nyrtfleury14
  • Locked
  • Question
Attachmate Extra macro moving to Reflection
Replies
1
Views
185
SkipVought
S
Vik12
  • Locked
  • Question
VBA causing excel to freeze
Replies
15
Views
237
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top