How to subtract Weeks from a Date in PowerApps?

(0) Share

Report

Posted on by SueA

555

Hi:

I have a Form with SharePoint List titled TASKS as my Data source.

The Fields are Due Date and Reminder Period in Weeks.

GOAL: While one keys in Reminder Period and then selects a Due Date, it should give an error message if the Reminder Date is less than Today.

Where, Reminder Date = Due Date - Reminder Period in Weeks.

QUESTION: How do I calculate the Reminder Date and save it in a variable varReminderDate

I can place a Label stating that "Please please select different value for either Reminder Period or the Due Date to make the Reminder Date in future." And, make this label visible only if varReminderDate < Today().

Note: I was able to do this using Power Automate easily but it takes a couple of minutes to run, save in SP List and messages the user after the fact. Thus, I would want to do the calculations in PowerApps itself to provide instant message before its submission if selected values are incorrect. See Attached scrrenshot.

Any help is appreciated.

Thank you,

Categories:

Building Power Apps

Screenshot 2023-0...

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @SueA ,

For this you can use the DateAdd function:

DateAdd( <DueDate>, -7*<ReminderPeriod>)

<DueDate> should ber repalced with a reference to the due date (DataCardValueX.SelectedDate) and <ReminderPeriod> should be replaced with a reference to the Reminder period (Value(DataCardValueY.Text)).

Was this reply helpful? Yes No
SueA 555 on at

Like (1)

Report

Thank you!
This worked.
My formula:
DateAdd(DataCardValue37.SelectedDate,-7*(DataCardValue49.Text),TimeUnit.Days)

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @SueA ,

Indeed that's it, although the TimeUnit argument is optional and, if not given, defaults to TimeUnit.Days. This is why I didn't included it in my earlier post.

Was this reply helpful? Yes No