Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Strange coding problem
I am filtering a table by a date, this is the code:
with thisformset.mainform.infoframe.stageentries
if .groupdate.option2.value = 1 then
set filter to project_id = thisformset.mainform.projnum.value and ;
ccustno = thisformset.mainform.compnum.value and ;
date >= ctod(.startdate.value) and ;
date <= ctod(.enddate.value)
else
set filter to project_id = thisformset.mainform.projnum.value and;
ccustno = thisformset.mainform.compnum.value
endif
endwith
If the second filter runs, the output is fine, but if the first filter runs, then the output is blank. If I replace the .startdate.value and .enddate.value with actually date strings, ie. '05/05/1999', then the output is fine. I've tried using alltrim and I've tried using the .text field, both don't help. If anyone has any ideas, they would be appericated. It driving me crazy!
thanks
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