I am in Oracle 11g and working with AppStudio 82.

One for the date fields comes in from Oracle as a YYYYMMDD in character format, but I need to convert it to a date field in AS.

Is there a function i can't find that might do this for me?

This message has been edited. Last edited by: FP Mod Chuck,

You could try HINPUT...

https://webfocusinfocenter.inf...ng/source/hinput.htm

Than you. I should have said that in the post. I tried that but it was so poorly un-optimized that I couldn't go forward with it in production. I'll keep poking. Thank you for your answer though!

Have you tried to convert using DATECVT instead? It works for date only and does not require the time portion to be in the date. might work better.

https://webfocusinfocenter.inf...9b-B343-9B01F25A24F0

you could always just convert it to an integer of I8YYMD.

How are you using the function? I assume it's in a DEFINE, therefore applies to every row. Try it in a COMPUTE, it will then be applied to the answer set.

or if you're using it in a filter, the SQL is probably not optimized. Could you post the code to have a better understanding?

John,

Another option if you are concerned with inefficiencies from WF would be to create a virtual field on the table in Oracle and do the conversion there. That way you aren't worrying about creating a define every time. then in the masterfile make sure the Actual value is date and usage is YYMD. Then your all set.