Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
2  
Care to be a bit more specific, maybe? What do you want to do? –  slhck Jun 23 '11 at 8:18
add comment

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.

1 Answer

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
add comment

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