linker3000
IS-IT--Management
Hello,
I am back again! Long time no see!
Once again I am using the Sun JDBC-ODBC module, connecting to an Access 97 database within iReport (Jasper Reports).
I am trying to do some date calculations but seem to be ending up with text fields and variants on CONVERT and CAST seem to not be implemented. Ideally, I'd like a date returned from:
IIF (tbl_PET_Pet.PET_CV2 >= now()+180, tbl_PET_Pet.PET_CV2 - 180, '' ) as vacdate2
In other words, if the vaccination date for a pet is >= 180 days in the future, return vacdate2 as that date - 180 days (as an approximation for a 6 monthly reminder).
I can;t seem to make this return a date value.
Thanks
I am back again! Long time no see!
Once again I am using the Sun JDBC-ODBC module, connecting to an Access 97 database within iReport (Jasper Reports).
I am trying to do some date calculations but seem to be ending up with text fields and variants on CONVERT and CAST seem to not be implemented. Ideally, I'd like a date returned from:
IIF (tbl_PET_Pet.PET_CV2 >= now()+180, tbl_PET_Pet.PET_CV2 - 180, '' ) as vacdate2
In other words, if the vaccination date for a pet is >= 180 days in the future, return vacdate2 as that date - 180 days (as an approximation for a 6 monthly reminder).
I can;t seem to make this return a date value.
Thanks