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

Question

Formula for Most Recent Date in a Table

Forms Version 10

Updated August 26, 2020

asked on August 20, 2020

We have a simple table (Table1) on our form with BeginDate, EndDate and Location. We need to capture the most recent end date to use in a late fee calculation. What formula should we use to find the most recent date no matter which row it appears in? We are using version 10.4. Thanks.

0 0

Replies

replied on August 21, 2020

The easiest way would be =MAX(Table.End_Date)

1 0

replied on August 26, 2020

I already tried =MAX(Table1.EndDate) without success, but I tried it again and it still did not work. The field just displays 12/30/1899 and does not change when I add dates to the table.

I started wondering if the problem was the field in the table is single line and the Most Recent End Date is a date field so I tried adding a new a new single line field and used the formula =MAX(Table1.Location) to get the max location, but it still does not work.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked August 20, 2020
Updated August 26, 2020
93 views