Question

App10 IEE Client

H
Rank
Userlevel 2
Badge +4

Need to extract Year part from Date type field , pl make a comment

4 replies

B
Rank
Userlevel 5
Badge +13

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

H
Rank
Userlevel 2
Badge +4

Thanks Bhagya for comment. That is form back end

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

N
Rank
Userlevel 7
Badge +11

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.

- Nalaka -
H
Rank
Userlevel 2
Badge +4

Hi Nalaka

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

Reply


Terms & ConditionsCookie settings