Jean-Claude Girard wrote:
> If you want entries on your $toDate to be included, you should use:
>
> AND to_date($toDate,'DD/MM/YYY') +1
>
> because to_date('01/01/02','DD/MM/YY') is the first of January 2002 at
> precisely midnight and 0 seconds. The "+1" gives you until January 2nd, 2002
> at midnight, thus including January 1st.
>
> Jean-Claude
hmm, i thought this was inclusive? I never had to do the +1 to get it to work
with the end dates specified...
now you are going to force me to look through my code arent ya? :)
chris
