Question

Using an Entered Date in a Separate Field's Formula

Forms Business Processes Laserfiche Cloud

Updated April 6, 2022

asked on April 6, 2022

Hello,

Within a LF form, I am attempting to use a date entered in a field as part of a formula for another field (to optionally add a suffix, depending on a radio button field).

Despite trying several different functions (TEXT, T) trying to get the date to show up as formatted in the field (vs a date code) nothing seems to return the desired result.

Does anyone know the trick for getting a date to transfer over to a different field via formula?

=IF(EXACT(batch_type, "BMO"),CONCATENATE(TEXT(check_date),"BMO"),check_date)

0 0

Answer

SELECTED ANSWER

replied on April 6, 2022

Hi Robert,

What your experencing is expected when using a date formated field to a text field.

What you could do is setup a few other fields that are text fields to capture the respective date componets (Month, Day , Year) and then concat them how ever you need them and still maintain the date format.

Then just hide the M, D and Y fields on the form.

Below is a screenshot with the formulas as default value on the field(s) to better pictate the configuration displayed.

Preview of the form:

Another alternative would be to use Javascript to populate the date.

Hope that helps!

1 0

replied on April 6, 2022

Thanks Troy!

MONTH, DAY, and YEAR were exactly what I was looking for. Seems like a date-to-formatted text function could be a helpful addition to Laserfiche to make this more streamlined.

0 0

Replies

replied on April 6, 2022

I have a form that creates an uploaded document name using a date in the calculation

0 0

replied on April 6, 2022

Thanks! Smart using RIGHT to get a mm/dd/yy format like that.

0 0

replied on April 6, 2022

Somebody showed it to me here. Welcome to the party. :)

0 0

You are not allowed to follow up in this post.

Question

Question

Using an Entered Date in a Separate Field's Formula

Answer

Replies

Sign in to reply to this post.