DateDiff$

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