This content has been translated automatically. Click here to view the French version.
 WINDEV WEBDEV WINDEV Mobile Others DateTimeDifference (Function) In french: DateHeureDifférence Calculates the difference between two dates and times.Remarks: It is also possible to use the '-' operator (minus) operator to calculate the difference between two dates. To display the result of this function in a Duration variable, use StringToDuration.Versions 17 and later This function is now available for iPhone/iPad applications.New in version 17 This function is now available for iPhone/iPad applications. This function is now available for iPhone/iPad applications.Versions 18 and later This function is now available in Android widget mode.New in version 18 This function is now available in Android widget mode. This function is now available in Android widget mode.Versions 21 and later This function is now available in Universal Windows 10 App mode.New in version 21 This function is now available in Universal Windows 10 App mode. This function is now available in Universal Windows 10 App mode.Versions 26 and later This function is now available for Apple Watch applications.New in version 26 This function is now available for Apple Watch applications. This function is now available for Apple Watch applications.Example // Temps écoulé depuis le 01/01/1998 à 12h15Diff is stringDiff = DateTimeDifference("199801011215", SysDateTime())// Affichage temps écouléInfo("Temps écoulé: " + CR + ... Left(Diff, 8) + "jours" + CR + ... Middle(Diff, 9, 2) + "heures" + CR + ... Middle(Diff, 11, 2) + "minutes" + CR + ... Middle(Diff, 13, 2) + "secondes" + CR + ... Middle(Diff, 15, 2) + "centièmes de seconde") // Pour remplir une durée à partir du résultat de DateHeureDifférenceDiff is string = DateTimeDifference("199801011215", SysDateTime())// convertir la différence dans une variable de type duréeDurée1 is Duration = StringToDuration(Diff, durationCenti) // --------------------------------------------// Autre solution possible // DateHeure1 est une DateHeure = "199801011215"// DateHeure2 est une DateHeure = DateHeureSys()// Durée1 est une durée = DateHeure2 - DateHeure1// ---------------------------------------------- // Affichage temps écouléInfo("Temps écoulé: " + Durée1.Day + "jours" + CR + ... Durée1.Hour + "heures" + CR + ... Durée1.Minute + "minutes" + CR + ... Durée1.Second + "secondes" + CR + ... Durée1.Millisecond + "millièmes de seconde") Syntax = DateTimeDifference( , ) : Character stringNumbers of days, hours, minutes and seconds elapsed between two dates in +/-DDDDDDHHMMSSCC format where:DDDDDD is the number of days elapsed between the two specified "Date - Time",HH is the number of hours,MM is the number of minutes,SS is the number of seconds,CC is the number of hundredths of a second.This result comes from the following operation: - . The result is contains the sign '-' if the is later than the .Caution: To assign this result to a Duration variable, use StringToDuration with the durationCenti constant. : String or Variable of type DateTimeStart date/time in the following format:YYYYMMDDHHmmSSCCYYYYMMDDHHmmSSYYYYMMDDHHmmYYYYMMDDHH : String or Variable of type DateTimeEnd date/time in the following format:YYYYMMDDHHmmSSCCYYYYMMDDHHmmSSYYYYMMDDHHmmYYYYMMDDHH Remarks The validity of the dates and times passed as parameters is checked. A message is displayed if the date or time is invalid. A "Date - Time" is considered invalid if:The date is invalid. You can check the validity of a date using DateValid.The time is invalid. You can check the validity of a time using TimeValid.This function cannot be used to calculate the difference between two dates before October 14, 1582 (the change from the Julian to the Gregorian calendar will not be taken into account). The date storage format allows you to store dates from 01/01/0001 to 12/31/9999.The calculations performed on dates by the WLanguage functions or by the WLanguage properties are accurate from January 1st 1583.Business / UI classification: Neutral codeComponent: wd270std.dll Minimum version required Version 9 This page is also available for…
 Video DateTimeDifference
 https://youtu.be/c-Ih6WpX4Wshttps://windevdesenvolvimento.blogspot.com/2019/05/dicas-2106-windev-webdev-mobile-data-29.html// EDT_BTN_cALCULAR_DIASdiferencia is string = DateTimeDifference(EDT_DATA_INICIAL_1, EDT_DATA_FINAL_1)duracao is Duration=StringToDuration(diferencia, durationCenti)EDT_dias_1=duracao..Day
 amarildo
 11 May 2019
 Display the result of DateTimeDifference
 DateTimeLOGIN = Table.MyLOGINDateTimeLOGOUT = Table.MyLOGOUTMyDuration = DateTimeDifference(DateTimeLOGIN,DateTimeLOGOUT)+"0"Table.MyDuration = MyDurationAdding the "0" to the result of the calculation is necessary to get a correct display!
 Guenter
 29 May 2018
 Example
 // Time passed since 01/01/1998 at 12:15sTDatahoraAgenda is string = Middle(StringToDate(EDT_DataAgendamento)+StringToTime(Middle(EDT_DataAgendamento,12,5)),1,12) //"199801011215"Diff is stringDiff = DateTimeDifference(sTDatahoraAgenda, DateSys() + TimeSys())//Display the time passed//Info("Time passed: " + CR + ...//Left(Diff, 8) + "days" + CR + ...//Middle(Diff, 9, 2) + "hours" + CR + ...//Middle(Diff, 11, 2) + "minutes" + CR + ...//Middle(Diff, 13, 2) + "seconds" + CR + ...//Middle(Diff, 15, 2) + "hundredths of a second") //Valida data nSMinutos is int = Val(Middle(Diff, 11, 2)) IF CBOX_Agendamento..Value = True AND Middle(Diff, 11, 2) < 30 Info("A data e hora agendada tem que ser maior do que 30 minutos") ok1 = False ELSE ok1 = True END