EDate Function in PowerFx Using Canvas Apps in Power Apps

Power Apps is a suite of apps, services, connectors, and data platforms that provide a rapid application development environment to build custom apps for your business needs. More Details: https://docs.microsoft.com/en-us/powerapps/powerapps-overview.

The EDate function in PowerApps is used to calculate a date that is a specified number of months before or after a given date. It is useful when you need to add or subtract months to/from a date.

The General syntax is EDate(DateTime, NumberOfMonths)

By reading this article, you can learn how to perform the EDate function in PowerFx using Microsoft Power Apps. Also, you will be able to learn Text Box and Label control in the Power Apps environment.

Step 1. Open the URL https://powerapps.microsoft.com/en-us/ in the browser for Power Apps.

Create an account with your Organisation Mail ID and log in after logging into your Power Apps account.

Step 2. First, Click Create (+ ), select Start with Page Design, and Select Blank Canvas.

Step 3. To test the power function, First Rename the Screen name as PAPFSCR.

Next, insert a Label control and set the Name and Text property as LblTitle and “EDate function in PowerFx using canvas App with Power apps”.

Next, insert a Label control and set the Name and Text property as LblCurrent and Current Date is.

Next, insert a Label control and set the Name and Text property as LblCurDate and Today().

Next, insert a Label control and set the Name and Text property as LblMon and "Number of Months to be added: "

Next, Insert a TextBox control and set the Name property as TxtMAdd.

Next, insert a Label control and set the Name and Text property as LblMSub and "Number of Months to be sub:"

Next, insert a TextBox control and set the Name property as TxtMSub.

Insert Button control and set the Name property as Calculate and Onselect property as UpdateContext({AddMonDate: Text(EDate(Today(), TxtMAdd.Text), "[$-en-US]dd/mm/yyyy")}); UpdateContext({SubMonDate: Text(EDate(Today(), TxtMSub.Text), "[$-en-US]dd/mm/yyyy")})

Next, insert a Label control and set the Name and Text property as LblAddedMon and "After added Month:"&AddMonDate.

Next, insert a Label control and set the Name and Text property as LblSubMon and "After Subtracted Month:" &SubMonDate.

Finally, save the App with the name PAPFEDate, and the form design looks like below.

Step 4. Now we can see the run your App in Power Apps Studio, and The output of the PAPFEDate is,

The Browser Display is,

After entering the added month, subtracted month click the calculate Button.

The Apple iPhone Display is,

The Tablet Display is,

Now, you have successfully tested the Power Fx – EDate function in the Power Apps Studio environment.