thanks for all the help,
what i ended up doing to get around it was to say
where trandate >= from_date and trandate<= (end_date + 1)
Slán
~M

PS sorry for not including messages in reply but i was getting a warning saying something about not allowing style code