Add Date or 1 year to Date Field in Confiforms

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

0 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.