up vote -7 down vote favorite
share [g+] share [fb]

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

link|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
feedback

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. See the FAQ for guidance on how to improve it.

1 Answer

up vote 9 down vote 
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.

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

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