Recent content by 51Sqn

Hi - the first statement results in this : Your second one works perfectly on test, however when I apply it to the *real* query it falls over with on ODBC call error - I'm using ODBC to link to an ancient Cobol based system ( something called cTreeSQL !!) But thanks for trying and for...

Hi This is my first post and I'm pretty sure that there is a straightforward answer .... but I can't find it on Google or anywhere else ! I have a table that has Julian Dates (ie Integer number of days since 01/01/1900). The system it relates to posts transactions as the current day minus 1 -...