web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How can I add 6 months...

Power Apps

Unanswered

How can I add 6 months from the actual date

(0) Share

Report

Report

Posted on by dkayt

517

Hi,

Actual date : (e.g.) 24.06.2022

I want to display in the date picker Actual date + 6 months = 24.12.2022

Do someone know how to sum date in power apps?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

AhmedSalih 6,678 Moderator on at

Like (2)

Report

@dkayt , I would use DateAdd function >> https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-dateadd-datediff

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.

Was this reply helpful? Yes No
Silvester. Akakpo 783 on at

Like (1)

Report
Hi @dkayt ,
try this
Text( DateAdd( YourDateValueHere, 6, Months ), "dd-mm-yyyy hh:mm" )
Please Accept as a solution if it works for you. Don't forget to also give it a like

Was this reply helpful? Yes No
Ashwin7104 671 on at

Like (1)

Report
Hey @dkayt ,

Please try the below formula

DateAdd(Today(), 6, Months)

Set the above formula in default date property of Date Picker and replace Today() with your actual date value / field.

Thanks.

Was this reply helpful? Yes No
dkayt 517 on at

Like (1)

Report

Thanks @AhmedSalih
Thanks @Silvester
Thanks @Ashwin7104
All your solutions worked as excepted. Have a nice weekend.

Was this reply helpful? Yes No

Join the conversation