DateAdd() with minutes is calculating the date wrong

(0) Share

Report

Posted on by johnjohn123

3,514

I have this formula, which is for adding a Date and add minutes to the date, as follow:-

ForAll(
 collCheckedDays,
 Collect(
 CollSelectedDaysDetails,
 {
 SelectedDate: Text(ThisRecord.Value,"mm/dd/yyyy"),
 SelectedStartTime: 
 Text(DateAdd(
 Text(ThisRecord.Value,"mm/dd/yyyy"),
 If(
 tgAllDayEvent_1.Value,
 ddlHalfDayPart_1.Selected.StartMinutes,
 ddlStartTimeBulk.Selected.Minutes
 )
 ,
 TimeUnit.Minutes
 ),"mm/dd/yyyy hh:mm")
 
 ,
 SelectedEndTime: 
 Text(DateAdd(
 Text(ThisRecord.Value,"mm/dd/yyyy"),
 If(
 tgAllDayEvent_1.Value,
 ddlHalfDayPart_1.Selected.EndMinutes,
 ddlEndTimeBulk.Selected.Minutes
 ),
 TimeUnit.Minutes
 ),"mm/dd/yyyy hh:mm")
 
 
 
 }
 )
);

but the result date from the AddDate will be as follow:-

although the minutes values will be either 540, 30 or 720... so why it is adding almost one and a half year?

Thanks

also this issue is only happening on Microsoft Edge, while working well on chrome and firefox.. i am totally confused !!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Why are converting the date to text before adding the minutes. This doesn’t make sense in my opinion. Maybe when powerapps converts it back to a date it has a problem with the formatting you used.

Was this reply helpful? Yes No