i need to calculate the number of days between my control (StartDte) and the
current date
StartDte is in this format m/d/yy with ainput mask of
99/99/00;0;_

the other unbound calculated field needs to show the number of days between
the 2 values.
other field is named (unbound) late

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

You can also type a statement within a query, such asDateDiff("d", Date(),
StartDte)The reason I use Date() is because Now returns the time also with
the date. Date just returns the date."Dave Elliott"
<(E-Mail Removed)> wrote in message
news:d99ke.80$(E-Mail Removed)...
>i need to calculate the number of days between my control (StartDte) and
>the current date
> StartDte is in this format m/d/yy with ainput mask of 99/99/00;0;_
>
> the other unbound calculated field needs to show the number of days
> between the 2 values.
> other field is named (unbound) late
>
>
>

why wont this give the difference between text463 and startdte ?
=DateDiff("d",[Text463],"StartDte")


"G. Vaught" <(E-Mail Removed)> wrote in message
news:eB$(E-Mail Removed)...
> Use the function DateDiff.
> Code versionDim TheDate As Date ' Declare variables.
> Dim Msg
> TheDate = InputBox("Enter a date")
> Msg = "Days from today: " & DateDiff("d", Now, TheDate)
> MsgBox Msg
>
> You can also type a statement within a query, such asDateDiff("d", Date(),
> StartDte)The reason I use Date() is because Now returns the time also with
> the date. Date just returns the date."Dave Elliott"
> <(E-Mail Removed)> wrote in message
> news:d99ke.80$(E-Mail Removed)...
>>i need to calculate the number of days between my control (StartDte) and
>>the current date
>> StartDte is in this format m/d/yy with ainput mask of 99/99/00;0;_
>>
>> the other unbound calculated field needs to show the number of days
>> between the 2 values.
>> other field is named (unbound) late
>>
>>
>>
>
>

On Mon, 23 May 2005 01:42:21 GMT, "Dave Elliott"
<(E-Mail Removed)> wrote:

>why wont this give the difference between text463 and startdte ?
>=DateDiff("d",[Text463],"StartDte")

Because the eight-letter text tring "StartDte" is not a valid date.

Use [StartDte] instead to tell Access that it's a table field.

John W. Vinson[MVP]