Validity of the datesCalculating the difference between two dates with the operators WINDEV WEBDEV WINDEV Mobile Others DateTimeDifference (Function) In french: DateHeureDifférence 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 // Time elapsed since 01/01/1998 at 12:15Diff is stringDiff = DateTimeDifference("199801011215", SysDateTime())// Display time elapsedInfo("Time elapsed: " + 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") // To fill a duration from the result of DateTimeDifferenceDiff is string = DateTimeDifference("199801011215", SysDateTime())// convert the difference into a duration variableDuration1 is Duration = StringToDuration(Diff, durationCenti) // --------------------------------------------// Other possible solution // DateTime1 is DateTime = "199801011215"// DateTime2 is DateTime = DateTimeSys()// Duration1 is Duration = DateTime2 - DateTime1// ---------------------------------------------- // Display time elapsedInfo("Time elapsed: " + Duration1.Day + "days" + CR + ... Duration1.Hour + "hours" + CR + ... Duration1.Minute + "minutes" + CR + ... Duration1.Second + "seconds" + CR + ... Duration1.Millisecond + "thousandths of a second") 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: - . This result contains the '-' sign if the is later than the .Caution: To assign this result to a Duration variable, use StringToDuration with the durationCenti constant. : Character string or DateTime variableStart date/time in the following format:YYYYMMDDHHmmSSCCYYYYMMDDHHmmSSYYYYMMDDHHmmYYYYMMDDHH : Character string or DateTime variableEnd date/time in the following format:YYYYMMDDHHmmSSCCYYYYMMDDHHmmSSYYYYMMDDHHmmYYYYMMDDHH Remarks Validity of the datesThe 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 operatorsThe 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: interval_duration is DurationIF date_time_1 > date_time_2 THEN interval_duration = date_time_1 - date_time_2ELSE interval_duration = date_time_2 - date_time_1END interval_duration is Duration = date_time_1 - date_time_2IF interval_duration < 0 THEN interval_duration = - interval_durationEND Business / UI classification: Neutral codeComponent: wd280std.dll Minimum version required Version 9 This page is also available for…