Need help with Subject line in VBS script for Email

I need a format which will use the current date -8 and the current date -1

Example would be:

MAIL.Subject = "the date is 3/15/2011 3/23/2011"

in a format similar to:

MAIL.Subject = "the date" & Mid(date1,1,InStr(1,date1," "))

not great at VB scripting, any help would be appreciated.
LVL 2
alexr54Asked:
Who is Participating?
 
alexr54Connect With a Mentor Author Commented:
figured it out

ate1 = DateAdd("d",-8,Now())
date3 = DateAdd("d",-1,Now())
MAIL.Subject = "the date" & Mid(date1,1,InStr(1,date1," ")) & Mid(date3,1,InStr(1,date3," "))
0
 
alexr54Author Commented:
figured it out
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.