Stop Updating The Submitted DateTime Picker DefaultDate Value After Editing.

(0) Share

Report

Posted on by ChiranJay

Hi All,

I have a DateTime Picker that has the DeafultDate value as Today()+3 as in the below screen capture.

Screenshot 1000'.png

The issue is when I submitted the form, it saves the DefaultDate value as expected. However, when we try to edit the form on a future day, the controls show the date as a new date with the calculated Today()+3 value.

As an example like in the above screen capture, the Target Launch Date is 23rd January 2022. But If I try to edit the record tomorrow, the new Target Launch Date will be calculated to 24th January 2022. This has to be stopped.

How can I resolve that?

Thanks in advance.

Chiranthaka

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

ChiranJay 72 on at

Like (0)

Report

Re: Stop Updating The Submitted DateTime Picker DefaultDate Value After Editing.

Thanks @VeGETzX . This works perfectly. 👌
Verified answer

VeGETzX 364 on at

Like (0)

Report
Re: Stop Updating The Submitted DateTime Picker DefaultDate Value After Editing.

You can solve this by checking if the date field in your data source is blank or not.

If it was blank, then DefaultDate is Today() + 3, but if it wasn't, just use its data as DefaultDate.

Your DefaultDate property of your date picker should be
If(IsBlank(Parent.Default),Today()+3,Parent.Default)