Hi, guys. I have a date field in my oracle database using the format number (201402 - meaning yyyymm). So, on WebFOCUS I get this number and put in a DEFINE field using the date type MYY (02/2014).

But when I use this DEFINE field in a TABLE command WebFOCUS can't translate this to SQL. I got the error:

quote:

FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2565 - THE OBJECT OF BY/ACROSS CANNOT BE CONVERTED TO SQL
FOC2571 - FIELD DT_COMP_CONCLUSAO HAS AN UNSUPPORTED DATA TYPE

So I've been searching which data types are supported to this conversion for Oracle type but I found nothing. Could you help me? Is there a list of this types?

This message has been edited. Last edited by: <Kathryn Henning>,

Add a define to your synonym something like -

DEFINE MYDATE/A6MYY = SQL.TODATE({your field}, 'mm/yyyy');,$

You'll have to check the Oracle SQL syntax as I do not have Oracle available at the moment. However, this should resolve to passed SQL OK.

T

Wow, didn't know you could do that.

Fantastic!