Web Design Discussion

Print Page | Close Window

Date diff

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Web Design Discussion
Forum Description: Discussion on web design and development subjects.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4247
Printed Date: 28 March 2026 at 1:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Date diff

Posted By: Phat
Subject: Date diff
Date Posted: 14 July 2003 at 8:36pm

Hi All,

Having issues changing this SQL to ASP.

SELECT tblMailingList.*, tblMailingList.Purchase, tblMailingList.Active, tblMailingList.Join_date
FROM tblMailingList
WHERE (((tblMailingList.Purchase)=False) AND ((tblMailingList.Active)=True) AND (DateDiff("d",[tblMailingList]![Join_date],Now())=1));

The datediff is not happy in ASP any suggestions.

Thanks