6
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!
Hello @ManishSolanki , Thank you so much! I have been trying for ages! You have saved me!
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
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?
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
Share
Report
All responses (
Answers (
