Purpose:
Returns the difference between two dates in days as string.
Composition of the format string: this is a normal string into which placeholders can be embedded.
Place holder |
Description |
%y |
Number of years |
%<n>y |
Years to <n> digits |
$y |
String "Years" |
%m |
Number of months |
%<n>m |
Months to <n> digits |
$m |
String "month" or "months" |
%w |
Number of weeks |
%<n>w |
Weeks to <n> digits |
$w |
String "week" or "weeks" |
%d |
Number of days |
%<n>d |
Days to <n> digits |
$d |
String "day" or "days" |
%h |
Number of hours |
%<n>h |
Hours to <n> digits |
$h |
String "hour" or "hours" |
%i |
Number of minutes |
%<n>i |
Minutes to <n> digits |
$i |
String "minute" or "minutes" |
%s |
Number of seconds |
%<n>s |
Seconds to <n> digits |
%.<n>s |
Seconds with <n> decimals |
$s |
String "second" or "seconds" |
Parameter:
Date First date value
Date Second date value
String (optional) Format
Return value:
String
Example:
DateDiff$(Date("01/01/2015"),Date("03/01/2015")) Result: 2 Months