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

Question

Question

Find date

asked on April 24, 2019 Show version history

Hello everyone, I have this case:

Field 1: Expiration Date (Type: Date)
Field 2: Previous days (Type: Number)
Field 3: Date Notice (Type: Date)
The user of field 1 provides a date, field 2 indicates the number of days before warning and based on this must be the value in field 3. (Field 1-Field2)

For example:
Field 1 is 20.04.2019.
Field 2 is 15
The field should be 05.04.2019

I would prefer this to be done on Forms, is it possible?.

Tranks a lot.

0 0

Replies

replied on April 24, 2019

Very easily actually. Set the formula for your "Warning Date" field to be

=Field1-Field2

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

Sign in to reply to this post.