Full date and day

[Simon]

On my order form i have delivery date field. I now have a button that
creats an email to tell the customer the delivery date.

in the VB code i have used me.deliverydate. This puts the correct date
on the email but its in the following format 8/9/2006 but i would like
it in the following format Friday 8th Septermber 2006.



I also have on the email the delivery time using me.deliverytime. But
this brings it up as the following format 2:00:00 PM but i would like
it as 2:00 PM

Can any one help

Thanks

Simon

 

[Ken Snell \(MVP\)]

In your code, replace the me.deliverydate with this:

Format(me.deliverydate, "dddd d mmmm yyyy")

Note that this will not add the ordinal suffix ("th") to the date number,
but it gives you all the other characteristics that you seek.