DateAdd to date and empty

(0) Share

Report

Posted on by llserra

137

I want to add some hours and minutes to a variable, but after change datetimeformat, the varialbe goes to empty.

I tryed:

Set(
 Hora930;
 DateAdd(
 DateAdd(
 DateValue(
 // DateValue5.SelectedDate;
 Today();
 DateTimeFormat.ShortDate
 );
 9;
 TimeUnit.Hours
 );
 30;
 TimeUnit.Minutes
 )
);;

But when i try to view Hora930 to a textbox its empty ,also when i try to view the variable in Powerapp variables.

But if i comment DateTImeFormat.ShortDate with // i see in the textbox: 10 marzo 2023

Does anybody know whats happend?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Hello @llserra ,
First you can use now() instead of today() to get the time
Today only refers to the date of today without the time while now refers to the date and time of now
And when you want to convert to a date&time value you have to use DateTimeValue instead of DateValue.

DateAdd( [DateAndTime], [Time you want to add], [Unit])

for example:
DateAdd( Now(), 2, TimeUnit.Hours)
Now= 3/10/2023 2:28 PM ( My Time)
The function will return => 3/10/2023 4:28 PM

Please refer my comment as accepted solution if it fix your problem,
Regards,
Oussama.

Was this reply helpful? Yes No
llserra 137 on at

Like (1)

Report

HI ,thanks it works!!! ,thanks a lot for your help

Was this reply helpful? Yes No