From: "Dominic J. Doucet-Lorang" <[EMAIL PROTECTED]>
> Is there some way of incorperating the datediff function into a query? I
> am trying to get only records that have a date difference of 30 days.
> Here is the query:
> <CFQUERY name="getkundeinfo" datasource="abx2" dbtype="ODBC">
> select distinct forsikring.*,kunde.*
> from forsikring, kunde
> where kunde.kundenr = #kundenr2# AND forsikring.id = #salg# AND
> forsikring.id = kunde.id and Abs(datediff("d", dos, #dos2#) LTE 30
> </CFQUERY>
>
datediff('d',dos,#dos2#)
use ' instead of "
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
