DateDiff Function

[Brogrim]

I have 2 dates and want to get the number of days between a date. I looked up the DateDiff function and got

DateDiff «interval», «date1», «date2», «firstweekday», «firstweek»)

In my ignorance I assumed it would be a simple

[Date1] - [Date2]


Can somone explain where the dates go in the above

Thanks in Advance

 

[Lilliabeth]

Did you try [Date1]-[Date2]? That should work, but it's vague. If you want to use datediff:

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