Unanswered

Add days to a different date field

(0) Share

Report

Posted on by Ewoud

117

Hi there, I am trying to add 30 days to a datefield. The extra 30 days should be calculated using a different date field. I found a few other topics about this but they seem not to work for me. Especially this topic seems similar to my question. But when I use the same code I get an error. It's Dutch but it's saying it has unexpected characters.

DatePicker 1 corresponds to the field 'Datum uitdienst' and DatePicker2 corresponds to the field 'Datum e-mail verwijderen'. I want DatePicker2 to add 30 days to DatePicker1. DatePicker1 has a default value of Today() to show current day but this date will change once the user starts filling in the form.

What am I doing wrong here?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Ewoud

Can you replace the commas with semi-colons in your formula, and see if that removes the error?

DateAdd(DatePicker1.SelectedDate;30;Days)

Was this reply helpful? Yes No
Ewoud 117 on at

Like (0)

Report

Hi @timl,

Thanks for the suggestion. Unfortunately it throws me a different error. Something about an invalid name and not recognizing the ID.

But then I changed the value of Datepicker into the name of the field which is 'Datum uitdienst'. It looks like that works, sort of. As you can see it doesn't add 30 days but just 8 days. And when I fill in the form and change the date of 'Datum uitdienst' nothing happens, and it also shows a default date of 31-12-2001.

I also tried to use DataCardValue5 but that also gives an error.

Was this reply helpful? Yes No
Ewoud 117 on at

Like (0)

Report

Sorry, forgot to add the second image.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (3)

Report
Hi @Ewoud

Looking at your screenshot, it looks like DatePicker1 is a card rather than a date picker control.

Can you expand the DatePicker1 node (the bit highlighted in yellow), and find the name of the date picker? It'll look something like DataCardValueXXXX - similar to the control that I marked in blue.

Next, use this control name in your formula like so and it should hopefully solve the problem.

DateAdd(DataCardValueXXXX.SelectedDate; 30; Days)

Was this reply helpful? Yes No
Ewoud 117 on at

Like (0)

Report

Hi @timl,

You are a genius. I tried a formula that didn't contain the 'SelectedDate' part. But now that I did it works like a charm.

Thank you very much for your help!

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Thanks @Ewoud! I'm glad the problem is solved.

Was this reply helpful? Yes No
Gnanavel_V 4 on at

Like (0)

Report

DateAdd(DatePicker2.SelectedDate,30,Days)
Now its updated u can use comma

Was this reply helpful? Yes No
Gnanavel_V 4 on at

Like (0)

Report

I want to display a day's count in 365.
I tried the DateDiff it working only for one year after it's counting like 356,357,358...
DateDiff( Now(), DateValue("1/1/2021") )

Was this reply helpful? Yes No
dropkic4u 24 on at

Like (1)

Report

The function didn't work for me until I changed the semi-colon to just a comma and add the "TimeUnit" like so:
DateAdd(DataCardValue55.SelectedDate,4,TimeUnit.Years)
I have a field called "Date of Purchase" and thereby add fours years to the "Warranty Expiration Date"
Maybe it has something to do with the language but nonetheless, it was enough to help solve my issue. Thanks for the help timl.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

You're welcome @dropkic4u - glad to help.

To clarify, the orginal post related to Power Apps running in the Dutch language. This uses a semi-colon as the function argument separator. If you're using English, the correct character as you've noted is a comma. Also, since the orginal post in 2019, it's now necessary to fully qualify the time unit by prefixing it with TimeUnit, which explains the second bit of behaviour that you're seeing.

Was this reply helpful? Yes No