New current_year column based on the Year column containing multiple years

[deepnandi]

Hi All, 

 I need help to extract current year from [Year] column which has multiple years to create a new current year column. Please the see the screenshot input column and output column.

Thanks in advance

[Qiu]

@deepnandi 
How about using DateTimeformat(DateTimeNow(),"%Y")

[ShankerV]

Hi @deepnandi 

Please use formula tool..

 

Many thanks

Shanker V

[deepnandi]

Thanks @ShankerV , I need to extract the current year which 2024 from the input column to create the new column. Hope this helps

[ShankerV]

Hi @deepnandi 

Can you please share the same date in the input column.

Need to check the date format.

Many thanks

Shanker V

[deepnandi]

Its not a date I have only years. the format of column is string.

[ShankerV]

Hi @deepnandi 

Please share the string, the input sample which you have attached doesnot gives full information to help.

Your input:

 

Many thanks

Shanker V

[CoG · Accepted solution]

If you need to overwrite the [Year] field then you can use the Formula Tool and @Qiu 's formula:

DateTimeformat(DateTimeNow(),"%Y")

Otherwise, you will need to be more specific as to your specific needs as @ShankerV has mentioned. You know what you need, but we do not. Be as simple and thorough as you can, include the exact structure of the input and then the sample output, which looks exactly how you need it to, and do this with two separate tables (not one that's merged together). This will help communicate your precise needs to the community.