year in date field is showing zero in the workflow

Question

Dear All,

I have a date field, extracting only year thru calculated field and using it in the email notification.

Your Annual Compliance Declaration for the year 0 has been completed. but in the list the value in the year is 2020.

Regards,

---

Harshavardhan

Answer 1

Hi Harshavardhan, 

You can create a calculated column, using the following formula to get an year from the date column:

=CONCATENATE(YEAR([Date column]))

Then you can use the calculated column in workflow.

Get an year from The date column in SharePoint for your reference:

https://www.c-sharpcorner.com/UploadFile/5b1f04/get-a-year-only-from-date-time-column-in-sharepoint/

This “SharePoint 2010 - Using SharePoint Designer, InfoPath and Other Customizations” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

Best Regards, 

Lisa Chen 

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 2

Hi Harshavardhan,

If a reply helps you, please remember to mark it as an answer.

Thanks for your understanding. 

Best Regards, 

Lisa Chen 

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 3

Hi Harshavardhan,

Please remember to mark the helpful post as an answer.

Thanks for your understanding. 

Best Regards, 

Lisa Chen 

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

Answer 4

Hello,

This forum will be locked down, if you still have issues about this question, you can continue to post in here before 8/10/2020. It is recommended to create a new question on Microsoft Q&A, we will continue to support you on the new home.

Best Regards,

Michael Han

---

"SharePoint" forums will be migrating to a new home on Microsoft Q&A !
We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !