Our users enter the date dd/mm/yyyy in BO. Access interprets the date as mm/dd/yyyy.
Therefore a condition (date between “01/02/2000” and “29/02/2000”) actually runs as (date between “02/01/2000” and “29/02/2000”). Believe it or not but ACCESS97 doesn’t reverse the (to date) for some reason. If your condition is date between “13/02/2000” and “29/02/2000” it works fine. Has anyone come across this problem and fixed it. I do not want the users to enter the date mm/dd/yyyy. The advanced tab on the date object in BO has the format of #dd/mm/yyyy#. the .sbo has InputDateFormat as “DD/MM/YYYY”.
Listserv Archives (BOB member since 2002-06-25)