PDA

View Full Version : Eight Weeks from Today



wildpianist
03-04-2009, 03:17 PM
Sorry to trouble you guys

I need a bit of code in Word that will automatically put 8 weeks from 'Today' (well system date) in the text.

I've tried to put Print date$+56 but it doesn't work :(

I've not done VB for a while and can't remember what I need to do.

It needs to be in the format of dd mmmmmmmm yyyy (ie 04 March 2009)

Hope you can help.

Kindest Regards

Dave

macropod
03-04-2009, 07:55 PM
Hi wildpianist,

Try something based on:
Print Format(DateAdd("d", 56, Date), "dd MMMM yyyy")