You’re offline. This is a read only version of the page.
Hello all,
What I am trying to accomplish is a text box that shows a new date stemming from hours added onto the date selected. In excel I was using:
=IF(D81="","",IF(AND(ISNUMBER(D81),F81=""),$C$77+(D81/24),IF(ISNUMBER(F81),$C$77+(F81/24))))
Thanks in advance for the assistance.
This is such a terrific way to help, thank you! However, I do not know why but looking at many of the syntax in these forum posts seems to not working in my new version of PowerApps fx.: If(IsBlank(xxxxxx.Update).....
I do not know why but the function does not work - Can you give me a hint as to why although I am using the exact same method as you have in the Gif/your screenshot? Greatly appreciated, thank you!
Hi @Sevendust,
Could you please share a bit more about your scenario?
Do you want the End Date/Time to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours?
If you want the End Date/Time field to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours within your Edit form, I think the DateAdd function could achieve your needs.
I have made a test on my side, please take a try with the following workaround:
Set the Default property of the End Date Data card to following formula:
If(
IsBlank(Actual_x0020_Hours_DataCard2.Update),
Start_x0020_Date_DataCard2.Update,
DateAdd(Start_x0020_Date_DataCard2.Update,Actual_x0020_Hours_DataCard2.Update,Hours)
)
Note: The Start_x0020_Date_DataCard2 represents the Start Date Data card control, the Actual_x0020_Hours_DataCard2 represents the Actual Hours Data card control.
The GIF screenshot as below:
More details about the DateAdd function in PowerApps, please check the following article:
Best regards,
Kris
Hi @Sevendust
The DateAdd function sounds like what you're after:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff
Use it like:
DateAdd(StartDate,Value(ActualHours),Hours)
Hope that helps
Hadyn
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (