PC Review

Reply

Rate Thread

Change Date code to yesterday/day before ,,,,

J.W. Aldridge

Guest

Posts: n/a

13th Jan 2009

How to change this portion:

& Format(Now, "mmm-dd-yy ddd")

of the line to reflect the day before today or yesterday?

(Full line here)
.Subject = "My recap" & " " & Format(Now, "mmm-dd-yy ddd")

Reply With Quote

Reply

« Change Date code to yesterday/day before ,,,, | Change Date code to yesterday/day before ,,,, »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Date code to yesterday/day before ,,,,	J.W. Aldridge	Microsoft Excel Programming	1	13th Jan 2009 04:00 PM
Change Date code to yesterday/day before ,,,,	J.W. Aldridge	Microsoft Excel Programming	0	13th Jan 2009 03:44 PM
Date = Yesterday?	Joris De Groote	Microsoft VB .NET	1	15th May 2006 11:59 AM
Inbox - Sort - Date: Today Date: Yesterday	Jan Groshan	Microsoft Outlook	2	24th Apr 2006 09:23 PM
Get yesterday date	=?Utf-8?B?TGkgUGFuZw==?=	Microsoft VB .NET	4	27th Jun 2005 11:26 AM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 12:34 AM.