I need to create macros for current date and yesterday's date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharyn K - 06 Nov 2004 20:29 GMT

in the format of mm/dd/yy. I don't have much programming experience, is
there an easy way to go about this? I created a macro for inserting today's
date using insert date, but it comes out 11/6/04 instead of 11/06/04 which is
the required format for my documents.

Thanks for any help.

Sharyn

Reply to this Message

Steve Yandl - 06 Nov 2004 22:01 GMT

Try something like this.

Sub DatesEnter()
Dim strToday As String
Dim strYesterday As String
strToday = "Today is " & Format$(Now, "mm/dd/yy")
strYesterday = "Yesterday was " & Format$(Now - 1, "mm/dd/yy")
Selection.InsertAfter strToday & vbCrLf & strYesterday
End Sub

Steve

> in the format of mm/dd/yy. I don't have much programming experience, is
> there an easy way to go about this? I created a macro for inserting
[quoted text clipped - 6 lines]
>
> Sharyn

Reply to this Message