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

Question

Question

Auto-Populate Dates in a table

Forms
Updated April 4, 2020
asked on April 3, 2020

I would like to auto-populate dates in a table based on a variable date entered by the user.

For instance if the user enters the date of 4/4/2020,

The first date in the table will be Sunday, 3/22/2020 (14 days prior to entered date),

The next will be Monday, 3/23/2020 (13 days prior) and so on...

 

0 0

Replies

replied on April 4, 2020
1 0
replied on April 4, 2020 • Show version history

After adding the additional column in your form (ROWID) as laid out in the post above

In your date field of the Table, your formula would look like the following.

Please check your variables name to match your forms values

=SUM(SUB(PayPeriodEnding,14),INDEX(TimeSheetTable.ROWID,ROW()))

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...