Answered

How to use multiple values (days, months, and years) with DateAdd function

(1) Share

Report

Posted on by TrayH

383

I'm trying to allow users to add a requested number of days, months, and/or years to a date that is being captured in my form. I've got the formula working fine with only one of these intervals at a time, but it doesn't seem to work if I try to add days, months, and years all at once.

For example, this works:

DateAdd(ThisItem.'Grace Period Date',ThisItem.'Additional Years',TimeUnit.Years)

But this does not:

DateAdd(ThisItem.'Grace Period Date',ThisItem.'Additional Years',TimeUnit.Years, ThisItem.'Additional Months', TimeUnit.Months, ThisItem.'Additional Days', TimeUnit.Days)

Not sure if I have a syntax issue or if DateAdd is just not able to do multiple different intervals at once. How can I get the values from the additional years, months, and days fields added to the Grace Period Date?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,757 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
Hi TrayH

Chain them like this
DateAdd( DateAdd( DateAdd( ThisItem.'Grace Period Date', ThisItem.'Additional Years', TimeUnit.Years ), ThisItem.'Additional Months', TimeUnit.Months ), ThisItem.'Additional Days', TimeUnit.Days )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
TrayH 383 on at

Like (0)

Report
Copy link

Link copied!

Thank you Warren! That did it!

Was this reply helpful? Yes No