Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Help with Building Where Clause for date range
I have a form that has optional date range textboxes on it - start date and end date. The data in those fields is text since I could not figure out how to make it a date datatype. I am building a SELECT statement, but since this field is optional, I figure I must build a string for my where clause and then put it in the select. I cannot figure out how to get the where clause to work. Any help is greatly appreciated.
whereclause = ''
startdate = ALLTRIM(THISFORM.txtStartDate.Value)
enddate = ALLTRIM(THISFORM.txtEndDate.Value)
IF !EMPTY(startdate)
whereclause = 'and invpost.invdate >= "&startdate"'
ENDIF
SELECT invpost.invno,invpost.custno,invpost.invdate,invitempost.itemno ;
FROM invpost INNER JOIN invitempost ;
ON invpost.invno = invitempost.invno ;
INTO CURSOR curResults ;
where invpost.custno = '&selectedcustomer' ;
&whereclause ;
ORDER BY invpost.invdate
Randy Wessels
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement