Date Difference Problem

[jeo]

I'm trying to figure out how many day are between now and a date on my form.
I've done a search, but I can't find much that talks about DateDiff().
Here is what I have so far and it's not working. I'm typing this value into a text box on a form.
=DateDiff(Day,Now(),"ASSIGNED_DATE_TIME")
I want the interval to be in days.
Thanks.

 

[KSimm]

the correst syntax is:

=DateDiff("d", [Date1], [Date2])

with the "d" indicating the interval to be calculated between the two date fields

 

[jeo]

Thank you, that worked.