I am trying to make a view in order to make a sales schedule to show all ads that are current or upcoming (so, to have it screen out any assigned to dates prior to today)I have this code, but a few earlier dates pop up, is this correct for what I want to do?:
SELECT (@Text(s_date) >= “04/01/2004” & FORM=“sales” & (@Text(s_date) != “10/31/2003”))
Thanks for your help!
Subject: Help selecting certain dates in a view
Don’t convert to text. That makes your operators work in an alphanumeric fashion where “1” (which means the text form of any date in October, November, and December) comes after “0”. If s_date holds a date, treat it as a date:
SELECT (s_date >= [4/1/2004] & FORM=“sales”)
Subject: RE: Help selecting certain dates in a view
It works, Thank you so much!!!