Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Lightbulb Unanswered: system date in access 2000???

    Hi,

    I want to retrieve the system date from the database system in Access. Likewise we retrieve from oracle " select sysdate from dual", I want the similar way in access. Anybody can help?

    thanks in advance..

    Atanu

  2. #2
    Join Date
    Aug 2002
    Posts
    28
    Not too sure if this is what you are looking for but if I want the system date on a report of form I use =now()

  3. #3
    Join Date
    Jun 2002
    Posts
    14

    system date in access 2000???

    You could try in Data (Properties) Data control source

    =Format(Date(),"Long Date") & " " & Format(Time(),"Long Time")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •