Add Date or 1 year to Date Field in Confiforms

Dhiraj Kr_ Gupta
Contributor
June 6, 2024

There is a field Last Submission Date , I want to Create a automated new Field ( Say New)which is 1 year after the Last Submission Date

For eg 

Last Submission Date.   New date

Jun 3, 2023.                Jun 3, 2024

May 4, 2022.               May 4, 2023

1 answer

1 accepted

0 votes
Answer accepted
Karine VANEL
Contributor
June 7, 2024

Hi @Dhiraj Kr_ Gupta ,
I used the decision helper add-on ( in atlassian Lab) :
Capture.PNG

Dhiraj Kr_ Gupta
Contributor
June 7, 2024

I have applied IFTTT macro> Create Update Confiforms Entry 

Set Parameters

entry=[entry.Id]&due=([entry.[LastApprovalDate]+31536000000)

But it is returning in Number format like 1718304740372000000. I want in date format

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 7, 2024

Is your “due” field is a text/number field pr a date/datetime?

Dhiraj Kr_ Gupta
Contributor
June 8, 2024

Thanks Alex, It was text but now it is working as i have changed to date

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events