Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
>Hi Mike,
>
>Thanks for all the info. I have this in my code...
>
>StartDate = ctod(THISFORM.txtStartDate.Value)
>EndDate = ctod(THISFORM.txtEndDate.Value)
I'd change that to lose the ctod(). In the init of the form.
THISFORM.txtStartDate.Value = {//}
THISFORM.txtEndDate.Value = {//}
To make them be dates from the start.
>
>* get the order rejects
>SELECT * FROM rejects ;
>WHERE daterecv BETWEEN StartDate AND EndDate ;
>ORDER BY vendorname, daterecv ;
>INTO CURSOR OrderRejects
>
and then use the m.startdate and m.enddate and it will be perfect! :)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only