You are viewing limited content. For full access, please sign in.

Question

Question

Need a formula within Forms that returns a value if a table column contains a date value over 90 days

Forms Business Processes Forms Layout Designer Classic Form Designer How To
Updated February 1, 2024
asked on February 1, 2024

Hey all,

I have an existing Forms process where I have a table with a date column and it is up to the user to determine how many rows they need. What I need is a way to determine if any of those dates in those rows are over 90 days from today (or a different date variable, I haven't been told which yet). The result can be anything such as TRUE, FALSE, 0, 1, etc. I just need to use it to add a condition within the process diagram.

I have tried multiple ways and I am making slow progress, but I wanted to ask around to see if someone has already figured something like this out.

I thank you all in advance.

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on February 1, 2024

Hi Brian

See sample below

In the OK Column I have the formula that looks to see if the Date is Column 2 is greater than todays date + 90 days, If so return Yes, otherwise No


=IF(INDEX(Table_1.Column2,ROW())>(SUM(TODAY(),90)),"Yes","No")

Below, the OutofScopeDays Counts how many Yes appear in the OK Column (Column_3)

=COUNTIF(Table_1.Column3,"Yes")

You can use the OutofScopeDays in your BP condition, if OutofScopeDays >=1, then you know you as that indicates you have a day in the table out of scope.

Shoudl work in either designer

Hope this helps

 

1 0
replied on February 1, 2024

This worked exactly how I needed it to.

Thanks!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...