App10 IEE Client

Hi @hewelkw,

You can use,  the fucntion EXTRACT in PLSQL.

Example: 
EXTRACT(YEAR FROM DATE '2003-08-22')

Result: 2003

More exmaples:

SELECT EXTRACT(YEAR FROM DATE '2003-08-22')
FROM dual

===========================================

SELECT EXTRACT(YEAR FROM revised_start_date)
FROM shop_ord_tab

Hope this helps!

Best Regards,
Bhagya

Thanks Bhagya for comment. That is form back end

I need extraction inside the IEE client itself. some kind for client method .

Hi @hewelkw, You could try to create a custom field for this in IEE. And for that you could use the keywords which Bhagya has mentioned above to extract the year from a date field of the application.

Hi Nalaka

Finding an Extract method from IEE client itself. There may be facilities like i guess