Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there an equivalent of Excel's DATE() function in Access 2007?

share|improve this question

closed as not a real question by grawity, Tom Wijsman, nhinkle Jun 23 '11 at 16:09

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Care to be a bit more specific, maybe? What do you want to do? – slhck Jun 23 '11 at 8:18
Dim year As Integer
Dim month As Integer
Dim day As Integer
Dim date As Date

date = DateSerial(year, month, day)

See also Date and Time Functions.

share|improve this answer
Reversal badge, everybody! – Sathya Jun 23 '11 at 10:59

Not the answer you're looking for? Browse other questions tagged or ask your own question.