These functions calculate the difference between two dates.

 

Syntax

YDiff( <Start Time>, <End Time> )

QDiff( <Start Time>, <End Time> )

MDiff( <Start Time>, <End Time> )

DDiff( <Start Time>, <End Time> )

HDiff( <Start Time>, <End Time> )

MnDiff( <Start Time>, <End Time> )

SDiff( <Start Time>, <End Time> )

Parameters

<Start Time> : A Time Dimension containing start time values.

<End Time> : A Time Dimension containing end time values.

Description

Returns the difference between <Start Time> and <End Time> in years, quarters, months, days, hours, minutes and seconds respectively.  YDiff, QDiff and MDiff always return whole numbers, while the rest may return fractions.

Examples

Consider the following raw data:

Store	Start Time	End Time	Amount
Store A	February 1, 2007 10:00am	February 1, 2007 07:00pm	100
Store B	February 1, 2007 09:00am	February 1, 2007 08:35pm	200
Store C	February 1, 2007 10:30am	February 1, 2007 05:00pm	300

 

Results:

Store	YDiff( [Start Time],[End Time] )	QDiff (...)	MDiff(...)	DDiff(,,,)	HDiff (...)	MnDiff(...)	SDiff(...)
Store A	0	0	0	0.38	9	540	32400
Store B	0	0	0	0.48	11.58	695	41700
Store C	0	0	0	0.27	6.50	390	23400