Mark A Matte
markamatte at hotmail.com
Tue Feb 13 15:22:42 CST 2007
Hello All, In A2K I ahve a form that has 2 unbound date fields...have input masks and formats as SHORT DATE...I have a query that uses these fields as criteria in a BETWEEN statement. The field in the table is a general date. I'm using 2 records to check...if I set the startdate and enddate on the form to the dates that are in the db...they return..but if I use ofther dates...nothing comes back. Example: StartDate:2/6/2007 EndDate: 2/13/2007 2 records: DT=2/9/2007 DT=2/13/2007 Using the above "between startdate and enddate" I return 1 record? If I change the startdate to 2/9/2007 then I return both IF I use 2/6 and2/17 as the start and end...I return NOTHING... Anyone...please help...I'm sure I've done something silly...but this just doesn't make sense??? Thanks, Mark A. Matte _________________________________________________________________ Invite your Hotmail contacts to join your friends list with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us