How to Create Function Field on Date Field to extract the Year

[Renee-17]

I have a table that contains a date field.  I'd like to create a function field on that table that extracts the year from the date field.  I need this for reporting.  How can I accomplish this?  Is it possible?

I'd like to perform the same steps to also extract the month. 

[Dr Atul G- LNG]

Hi @Renee-17 

https://www.servicenow.com/community/developer-forum/extract-month-year-from-date-into-a-string/m-p/...

[Renee-17]

I've looked at these but don't see how I can use them to create a Function Field for a table.  I have to use glidefunction.  For example:

       glidfunction:substring(DisplayName,'1','4')

I'd like to replace DisplayName with Date and and just extract the year part of the date but date is not a text field so is there anyway of doing this via creating a function field?

[Vasantharajan N · Accepted solution]

@Renee-17 - Please try with glidefunction:substring(sys_created_on,"1","4").

Note: I've used sys_created_on column to showcase the result. You can use your own column. 

Result