How to show in one textbox the date and time?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • eneyardi
    New Member
    • Jul 2010
    • 180

    How to show in one textbox the date and time?

    I want the one textbox in my form have a current date and time,

    my first try is =date() The format is General
    but it only shows date, but when you see sample of general format there is also time. I want my textbox look like this Monday, January 21, 2011 09:05 AM or 01/21/11 09:05 AM
    Pls.. any help or idea will be highly appreciated. thanks..
  • Michael Brown
    New Member
    • Jan 2011
    • 6

    #2
    I believe Now() should do the trick.

    Comment

    • eneyardi
      New Member
      • Jul 2010
      • 180

      #3
      thanks it works!

      Comment

      Working...