There is help for the Format function, you know.

You'd use something like this:

Format(date, "yyyymmdd")

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Glen.Cooper" wrote in message
...
snip
Hi,

Can you tell me how to write into the code above a way to change the
format to YYYY/MM/DD please?

I cannot figure it out...

glen


--
Glen.Cooper
------------------------------------------------------------------------
Glen.Cooper's Profile:
http://www.thecodecage.com/forumz/member.php?userid=613
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=121980