am/pm not registering in calculation

[Noel2]

This is probably a quick fix, but I can't for the life of me figure it out. I have a text box in my page footer on my report where I would like it to turn out like the following:

Last Modified on Monday, August 04, 2003 at 1:45 pm

The problem that I am having is that it is not pulling this up. I get everything except for the time factor solidified. I have scanned through this forum and others and cannot find a solution. The closest that I have com is having the source equal to the following:

="Last Modified on " & Format(Date(),"Long Date&quot & " at " & Format(Time(),"h:nn""tt""&quot

Then I receive:

Last Modified on Monday, August 04, 2003 at 13:45tt

Please let me know if you have the answer.

Thank you

 

[Noel2]

nevermind... I apologize for posting this... I just figured it out. Made it more complicated than it needed to be.

="Last Modified on " & Format(Date(),"Long Date&quot & " at " & Format(Time(),"h:nn am/pm&quot

did the trick.

Thanks