Filtering around DateTime values in BDC

We get asked about filtering around datetime fields quite a lot so decided the best thing to do was to create a wiki page entry on it….check it out here:

http://support.lighteningtools.com/default.asp?W55