Answered

Duplicate date in another column with year change

(0) Share

Report

Posted on by Pavel48n0sh

Hi!
I've a list with hire date of employees.

I am using a web part on my homepage to display Anniversaries.
It is designed in SPFx and requires an additional Internal Hire Date column for calculation, which is the same date as Hire Date, only the year is always 1970. This is done to filter by day, week, and month.

Manually entering the same date each time in this column is not very convenient. How can I build a flow so that the date is automatically substituted the same, only the year always changes to 1970?
The format of the Calculated column is not suitable because this format cannot be filtered.

This is how I started my flow, need to understand what formula to insert for replacement:

I have the same question (0)

All responses (3)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
Re: Duplicate date in another column with year change

Hi @Pavel48n0sh ,

Please try:

addToTime(internalHireDate,sub(int(formatDateTime(HireDate,'yyyy')),1970),'year')

Best Regards,

Bof

Was this reply helpful? Yes No
Pavel48n0sh 87 on at

Like (0)

Report

Re: Duplicate date in another column with year change

Dear @v-bofeng-msft,
I tried to add this formula, but got an error.

Perhaps this is due to the fact that my Internal Hire Date column is initially empty and the value should be automatically entered into it.
Both columns Internal Hire Date and Hire Date are in Date and Time format.
Could you help please?

Was this reply helpful? Yes No
Verified answer

Pavel48n0sh 87 on at

Like (0)

Report

Re: Duplicate date in another column with year change

It seems that I was able to achieve the desired result. Here is my final solution.

Was this reply helpful? Yes No