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
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.
@deepnandi How about using DateTimeformat(DateTimeNow(),"%Y")
Hi @deepnandi
Please use formula tool..
Many thanks
Shanker V
Thanks @ShankerV , I need to extract the current year which 2024 from the input column to create the new column. Hope this helps
Can you please share the same date in the input column.
Need to check the date format.
Its not a date I have only years. the format of column is string.
Please share the string, the input sample which you have attached doesnot gives full information to help.
Your input:
