It works fine, no errors and it seems to get correct data but the mysql
manual and some other books doesn't mention anything about BETWEEN being
used like this and therefor I'm not completely sure, anybody with any
experience with my example?
Erfan Shirazi
Application Developer, I
Hi all
I have a question about BETWEEN.
Could it be used to look up fields which have a date between to date fields?
Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
tEffectivedate and tExpirationdate are DATE types.
Best Regards,
--
Erfan Shirazi
Application
Hi all
I have a question about BETWEEN.
Could it be used to look up fields which have a date between to date fields?
Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
tEffectivedate and tExpirationdate are DATE types.
Best Regards,
--
Erfan Shirazi
Application
