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!

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

Date for Access generated email

Status
Not open for further replies.

delmardog

Programmer
Nov 27, 2002
2
0
0
US
This should be easy but I am lost.

I have a field called [sdate] and let say the date is
11/15/2002 that I want to alert some one to.

In the email I generate through VB, I want the email to say
Hello please meet me on Friday, 11/15/02.

The question is how do I tell access to give me the word "Friday" this is easy in a form or report because you just set the format to Long Date but in VB I am stumped.
 
Never mind got it
should be
Format([sDate], "dddd, mmm d, yyyy")
 
Hi,

delmardog's right but there is a more cool function:
FormatDateTime

Tibi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top