Dates, dates...too many dates...

[Mermogoat]

Two questions:

First of all, is there a way to subtract dates? I have two dates, the date a house was complete and then the current day, if I want to find out how many days old it is, how can I do that?

Second, When I use OpenReport and as part of my WHERE expressions, I have this as my parameter:

DateValue([RequestDate]) Between " & StartDate & " And " & EndDate

Request Date is the field in the query(RecordSource for the report), and Start/EndDate are var's of type Date on my form that opens up the report. For some reason though, this doesn't work

 

[KulasCage]

On your first problem, i used datediff: use help file for the syntax.

example:

Dim TheDate As Date ' Declare variables.
Dim Msg
TheDate = InputBox("Enter a date")
Msg = "Days from today: " & DateDiff("d", Now, TheDate)
MsgBox Msg

sorry on your second problem, i don't get what you mean. maybe someone experts here can answer that.

 

[Mermogoat]

Can anyone else help me out with my second question?