I'm using O2003. I have the following script that returns the
following values: day of week and date in long format

"Wednesday, June 08, 2005"

Sub ShowDate()
Item.Body = FormatDateTime(Date, vblongdate) & " - "
End Sub

Sub CommandButton1_Click()
Call ShowDate()
End Sub

Is there a way to format the date so it only displays: "June 08, 2005"

thanks

srm

Try this:
I commented out the second line and inserted the MsgBox to demonstrate.
Sub ShowDate()
' Item.Body = Format(Date, "mmmm dd, yyyy") & " - "
MsgBox = Format(Date, "mmmm dd, yyyy") & " - "
End Sub
Mark

"srm" wrote:

> I'm using O2003. I have the following script that returns the
> following values: day of week and date in long format
>
> "Wednesday, June 08, 2005"
>
> Sub ShowDate()
> Item.Body = FormatDateTime(Date, vblongdate) & " - "
> End Sub
>
> Sub CommandButton1_Click()
> Call ShowDate()
> End Sub
>
> Is there a way to format the date so it only displays: "June 08, 2005"
>
> thanks
>
> srm
>
>

Mark:


Thanks, but it seems the Format command doesn't work in the Script
Editor. I get a type mismatch.

Any ideas.

Shawn