Answered

Setting the default value for a Date field as "Today()" will always show today date

(0) Share

Report

Posted on by johnjohn123

3,514

I set the default value for a date field to be equal to Today(), but even when i edit an item which have a date value, the date value will be set to Today.. and advice on this, how i can preserve the value of the Date field?

Categories:

Building Power Apps

I have the same question (0)

All responses (25)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Consider this:

If(YourFormName.Mode=FormMode.Edit,Parent.Defaut,Today())

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@eka24
but if in edit mode the field does not have a value then i need to set it to the default.. your formula will not work is this correct?

i tried this formula "If(IsBlank(Parent.Default),Today(),Parent.Default)" but it did not fix the issue....

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

The formula is on the EditMode not a new form.

If it in a NewMode, it will pick Today().

For EditMode, it picks whatever value is in the datasource, so if its blank in the datasource, the datefield will also be blank. Until the user changes the date

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@eka24but if the date field is empty then i need it to get Today() by default i tried this formula "If(IsBlank(Parent.Default),Today(),Parent.Default)" but it did not fix the issue

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

In that case create a variable OnVisible of the Screen:

Set(varDate,DateValue1.SelectedDate)

Then Change the formula to:

If(!IsBlank(varDate) && Form1.Mode=FormMode.Edit,Parent.Default,Today())

Remember after setting the variable, navigate to a different screen and back before it takes effect

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@eka24i did not get your point.. why i need to use a variable ? why i can not simply say "If(IsBlank(Parent.Default),Today(),Parent.Default)"??

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Parent.Default will not work for New Mode (NewForm)

I guess the formula should work both for new and edit mode?

Again Parent.Default is not a control

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@eka24 can you please explain your point :-

Parent.Default will not work for New Mode (NewForm)
I guess the formula should work both for new and edit mode?
Again Parent.Default is not a control

in more details?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Hmmm...didn't we just cover Coalesce in another thread?? 😉

Coalesce(Parent.Default,Today())

If there is a value in the underlying record, use that, if not, use Today()

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Generally, the formula IsBank() should reference the Date picker. That is if the Date picker is Blank, then Today.

Now this create a circular reference. That is the more reason I used the variable.

The formula you quoted doesn't make any reference on the mode of the form. That is why in your original post both edit mode and new mode of the form gave you Today's date without any retrieval of Data from the Datasource.

Now on your formula.

Does this work:

"If(IsBlank(Parent.Default),Today(),Parent.Default)"??

Also does the approach I gave work?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No