[RESOLVED] Formatting Now Function

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.

Format$(Now, vbLongDate)

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

YOu could try this.

VB Code:

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

Hope this helps!!
:wave: :thumb: :wave:

Thanks, exactly what I was looking for.

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

VB Code:

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

Hope this helps!!
:wave: :thumb: :wave: