I've got a database that needs to display records between 2 dates.
At the moment I've got a form with 2 text boxes on - one for datefrom and one for dateto
My plan was to format and store the values from these text boxes as global variables
DateFrom = Format(Me.DateFrom, "yyyy/mm/dd") DateTo = Format(Me.DateTo, "yyyy/mm/dd")
that I cam then pass into a passthrough query with this criteria for field called dateCollected
HAVING (((Collections.DateCollected) str_to_date(datefrom, ‘%y/%m/%d’) and str_to_date(dateto, ‘%y/%m/%d’)) AND ((dbo.udfRawHazPropsList([ConsignmentNoteNumber],[ewc_code])) Is Not Null))
However, no matter what I try I can't get this to work. Any ideas as to a solution would be much appreciated!