JoeBoy
|
| Posted: 11/29/2004, 8:00 AM |
|
Whats wrong in this:
(DATEDIFF(day, RefDate, {s_RefDate2}) >= 121)
I need the number of days between the Database field "RefDate" and the url parameter "RefDate2"
It works when I use:
(DATEDIFF(day, RefDate, {fn NOW() }) >= 121)
or if I use a specific date in this format #01/01/2000#
What Im doing wrong?
ASP, SQL
|
|
|
 |
mrachow
Posts: 509
|
| Posted: 11/30/2004, 1:54 AM |
|
I'm using for example
xyz = DateDiff("d", OwnOrders.To.Value, Now())
_________________
Best regards,
Michael |
 |
|
|
