Como Restar fechas ?

(0) Share

Report

Posted on by JosueCR

Saludos tengo una pequeña app en la que necesito restar 2 fechas. pero no logro obtener en resultado deseado.

Puedo capturar las fechas pero en la operación de la restas no obtengo el resultado.

Los datos se almacenan en Excel.

 Text(FechaRevisa.SelectedDate + Time(
 Value(HourRevisa.Selected.Value);
 Value(MinuteRevisa.Selected.Value);
 0
 )))-(Text(FechaRecibe.SelectedDate + Time(
 Value(HourRecibe.Selected.Value);
 Value(MinuteRecibe.Selected.Value);
 0
 )))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hola @JosueCR

Use the DateDiff() function. The Syntax is DateDiff( StartDateTime, EndDateTime [, Units ] ). The units default to Days but Minutes, Hours, Months, Quarters, or Years can be used intead.

Was this reply helpful? Yes No
JosueCR 53 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp wrote:
Hola @JosueCR
Use the DateDiff() function. The Syntax is DateDiff( StartDateTime, EndDateTime [, Units ] ). The units default to Days but Minutes, Hours, Months, Quarters, or Years can be used intead.
@Drrickryp wrote:
Hola @JosueCR
Use the DateDiff() function. The Syntax is DateDiff( StartDateTime, EndDateTime [, Units ] ). The units default to Days but Minutes, Hours, Months, Quarters, or Years can be used intead.
(DateDiff(FechaRecibe.SelectedDate+Time(Value(HourRecibe.Selected.Value);Value(MinuteRecibe.Selected.Value);0);FechaRevisa.SelectedDate+Time(Value(HourRevisa.Selected.Value);Value(MinuteRevisa.Selected.Value);0);Minutes))

logre hacerlo pero obtengo el resultado en segundos... como puedo pasarlo a formato Hh:Mm
horas y minutos?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JosueCR

Try

Text(RoundDown(DateDiff(CurrentTime,InitialTime,Seconds)/3600,0),"00")&":"&
Text(If(RoundDown(DateDiff(CurrentTime,InitialTime,Seconds)/60,0)>59,0,RoundDown(DateDiff(CurrentTime,InitialTime,Seconds)/60,0)),"00")&":"&
Text(Mod(DateDiff(CurrentTime,InitialTime,Seconds),60),"00")

Was this reply helpful? Yes No
JosueCR 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Gracias,
Pero tu respuesta me dejo mas confundido de lo que ya estaba. 😥

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Lo siento mucho!!

Was this reply helpful? Yes No