Date comparison in Where clause?

[thatguy]

Hey there folks--

I'm trying to build a query during runtime to populate a grid based on a date range. One of the fields in the grid is a DateTime and the date range text box values init to "=date()", so they return date values.

I'm wondering if there's a more efficient way to do date comparisons than this:

ldstdate = thisform.txtstdate.value
ldenddate = thisform.txtenddate.value

lcsqlst = "SELECT * FROM audit WHERE (ddate >= {^" +;
 ALLTRIM(STR(YEAR(ldstdate))) + "/" + ;
 ALLTRIM(STR(MONTH(ldstdate))) + "/" + ;
 ALLTRIM(STR(DAY(ldstdate))) + ;
 "} AND ddate <= {^" + ;
 ALLTRIM(STR(YEAR(ldenddate))) + "/" + ;
 ALLTRIM(STR(MONTH(ldenddate))) + "/" + ;
 ALLTRIM(STR(DAY(ldenddate))) + ;
 "} ORDER BY ddate DESC INTO CURSOR curgrdaudit"

This works, but I'm wondering if there's an easier way to get a date value into the SQL string for a date-to-date comparison.

Thanks
-- michael~

PS.- Anyone know when the search function is gonna be working again?

 

[jimstarr]

Hi michael,

Date values can be compared directly as in

?date1 <= date2

Just convert your datetime value to date using TTOD and you're all set.

Jim

 

[craigber]

Better yet, just use the DATE(nYear, nMonth, nDay) function.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[ramani]

HI

You can use

DTOS(DATETIME()) = DTOS(DATE())

Hope you get the idea

____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[ramani]

To be more precise..

BETWEEN(DTOS(DateTimeField),DTOS(fromDate),DTOS(toDate))



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/