I have an app where users can select either a red, amber or green button and based on it, i want to create a formula that adds a certain amount of months to today's date:
If user press Red, Today() + 3 months
Amber: Today() + 6 months
Green: Today() + 12 months
So if i press Red, i will get 08/01/2020
How can i construct the formula to yield the added amount of month?
You can use the DATEADD function like this:
Red: DateAdd(Today(), 3 , Months)
Amber: DateAdd(Today(), 6 , Months)
Green: DateAdd(Today(), 12 , Months)
Here's the general function parameters:
DateAdd( DateTime, Addition [, Units ] )
Link to Documentation
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
190 | |
95 | |
65 | |
63 | |
58 |
User | Count |
---|---|
243 | |
163 | |
91 | |
79 | |
79 |