Date formula help

[MyLifeServices]

I am developing a web report and the below formula generates an error. Can anyone provide the correct syntax>

Session("SelectionFormula&quot = "DateDiff(" & chr(34) & "d" & chr(34) & " , {debtors.Response14}, " & DATE & &quot > 0"

The debtors.Response14 field is an Access 2000 database field.

 

[MyLifeServices]

To clarify the DATE needs to be a variable. What is the format for the date?

 

[synapsevampire]

Try something like:

Session("SelectionFormula&quot= date & "> {debtors.Response14}"

Though you may have to convert the date to a string.

Even if we got yours working, it wouldn't pass the selection criteria along to the database.

-k

 

[synapsevampire]

This format should work:

#2002/3/12#

-k