Answered

Formulat to calculate 6 weeks back based on entered response from form

(0) Share

Report

Posted on by HolaOla

Hello,

I have a flow of a form that feeds into a List. However I am having difficulties with a date and time formula. I would like to have a formula in a column labelled Kappa form submission that automatically calculates the date 6 weeks prior based on what the date input in the column planned release is.

I am unsure if I enter this formula in the flow directly or if I have to create another flow for it and what the formula would be.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @HolaOla

You could use expression to subtract 42 days (6 weeks) from the submission date:

if(empty(<releasedate>),null,addDays(<releasedate>,-42,'yyyy-MM-dd'))

pls replace 'releasedate' with the actual release date column in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
HolaOla 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @ManishSolanki , thank you so much for your help. I tried entering the expression and replacing releasedate wit the dynamic content equivalent but I get an error that says that the expression is invalid. Should the <> be present?

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @HolaOla

Sry for the confusion, <> should not be included in the expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
HolaOla 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @ManishSolanki , Thank you so much! I have been trying for ages! You have saved me!

Was this reply helpful? Yes No