[RESOLVED] Formatting Now Function

[doofusboy]

How would I get the Now function in VB to return this:

Wednesday, 8/3/2005 10:33:04 AM

instead of just:

8/3/2005 10:33:04 AM

?

Any assistance appreciated.

[penagate]

Format$(Now, vbLongDate)

At least, I think it is LongDate. At any rate, Format$ is the function you want.

[Bombdrop]

YOu could try this.

Format(Now, "DDDD, dd/MM/YY")

Hope this helps!!

[doofusboy]

Thanks, exactly what I was looking for.

[Bombdrop]

if you widh to show am or pm just ammed like so.

Debug.Print Format$(Now, "DDDD, dd/MM/YY hh:mm:ss am/pm")

Hope this helps!!