Question

Laserfiche Forms Date Calculation Question

Forms

Updated May 11, 2022

asked on May 11, 2022

Hello,

We have a form that uses lookup rules to populate a table field. One of the fields is a date field that populates a hire date. We have a hidden date field that we are trying to pull the hire date into and add 60 days.

Can someone help us with the calculation that would automatically convert this to a date field again? When we use =HireDate+60 it throws an error. When we remove the calculation the field populate with a number value instead of a date.

Thanks.

0 0

Answer

SELECTED ANSWER

replied on May 11, 2022

The error is correct, your variable name is incorrect. To use the correct variable name, use the > next to the fx button on the toolbar above your calculation to choose the correct variable.

After that you will need to do something like this:

=INDEX(Table.Hire_Date,1)+60

Table.Hire_Date is the variable name of the date field in my table. Your variable name will be different dependent on how you named your table.

0 0

Replies

replied on May 11, 2022

I was able to use a formula to add 60 days. I added two date fields to my form, Start Date and Add 60 Days. I added a formula to the Add 60 Days field and it calculates correctly.

1 0

View 5 previous replies

replied on May 11, 2022

This is what our forms previous version had. However, once we put the Hire Date field in a table and added a lookup from SQL to populate that date it no longer works.

0 0

replied on May 11, 2022

Can you post a screenshot of your form?

0 0

replied on May 11, 2022

No problem. Here are two screenshots. The first shows the variable from the table and the second shows the calculation error. Thanks.

HireDate.PNG (34.86 KB)

| Download

HireDate3.PNG (29.3 KB)

| Download

0 0

replied on May 11, 2022

Ah, so your Hire Date field is in a table and your HiddenHireDate field is outside of the table. Will there ever be more than 1 row in the Applicant Information table?

1 0

replied on May 11, 2022

No. Just that one row.

0 0

SELECTED ANSWER

replied on May 11, 2022

The error is correct, your variable name is incorrect. To use the correct variable name, use the > next to the fx button on the toolbar above your calculation to choose the correct variable.

After that you will need to do something like this:

=INDEX(Table.Hire_Date,1)+60

Table.Hire_Date is the variable name of the date field in my table. Your variable name will be different dependent on how you named your table.

0 0

replied on May 11, 2022 • Show version history

Thank you! It worked.

0 0

replied on May 11, 2022

You're welcome.

0 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche Forms Date Calculation Question

Answer

Replies

Sign in to reply to this post.