ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Standard functions / Date and time functions
  • Validity of the dates
  • Calculating the difference between two dates with the operators
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Calculates the difference between two dates and times.
Remarks:
  • You can also use the '-' (minus) operator to calculate the difference between two dates (see Remarks).
  • To display the result of this function in a Duration variable, use StringToDuration.
Example
// Temps écoulé depuis le 01/01/1998 à 12h15
Diff is string
Diff = 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érence
Diff is string = DateTimeDifference("199801011215", SysDateTime())
// convertir la différence dans une variable de type durée
Duré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
<Result> = DateTimeDifference(<Start date/time> , <End date/time>)
<Result>: Character string
Numbers 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 operation: <End Date/Time> - <Start Date/Time>.
This result contains the '-' sign if the <Start date/time> is later than the <End date/time>.
Warning To assign this result to a variable of type Duration, you need to use function StringToDuration with the constant durationHundredth.
<Start date/time>: Character string or DateTime variable
Start date/time in the following format:
  • YYYYMMDDHHmmSSCC
  • YYYYMMDDHHmmSS
  • YYYYMMDDHHmm
  • YYYYMMDDHH
<End date/time>: Character string or DateTime variable
End date/time in the following format:
  • YYYYMMDDHHmmSSCC
  • YYYYMMDDHHmmSS
  • YYYYMMDDHHmm
  • YYYYMMDDHH
Remarks

Validity of the dates

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.
WLanguage functions and WLanguage properties make accurate calculations on dates from January 1st, 1583.

Calculating the difference between two dates with the operators

The DateTimeDifference function can be replaced by the '-' operator. You can also assign the result directly to a variable of type Duration, which allows you to use a negative duration.
Examples: 
duree_intervalle is Duration
IF date_heure_1 > date_heure_2 THEN
	duree_intervalle = date_heure_1 - date_heure_2
ELSE
	duree_intervalle = date_heure_2 - date_heure_1
END
duree_intervalle is Duration = date_heure_1 - date_heure_2
IF duree_intervalle < 0 THEN
	duree_intervalle = - duree_intervalle
END
Business / UI classification: Neutral code
Component: wd300std.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Video DateTimeDifference
https://youtu.be/c-Ih6WpX4Ws

https://windevdesenvolvimento.blogspot.com/2019/05/dicas-2106-windev-webdev-mobile-data-29.html

// EDT_BTN_cALCULAR_DIAS

diferencia 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.MyLOGIN
DateTimeLOGOUT = Table.MyLOGOUT
MyDuration = DateTimeDifference(DateTimeLOGIN,DateTimeLOGOUT)+"0"
Table.MyDuration = MyDuration

Adding 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:15
sTDatahoraAgenda is string = Middle(StringToDate(EDT_DataAgendamento)+StringToTime(Middle(EDT_DataAgendamento,12,5)),1,12) //"199801011215"
Diff is string
Diff = 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
adrianoboller
27 Nov. 2015

Last update: 03/28/2025

Send a report | Local help