KB11120: Introduction to some of the date and time functions for MicroStrategy

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).

8575
FunctionBrief DescriptionNotesDaysBetweenReturns the difference in days between two dates, as an integer. The difference is number of day boundaries crossed, not number of 24-hour periods elapsed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric M01 = DaysBetween(CurrentDate(), '9/1/2004'). Use of M01 in Microsoft SQL Server 2000 would result in DATEDIFF(GetDate(), '9/1/2004').DateReturns the date portion of a date/time column. The time is truncated, not rounded.Create a metric M02 = Date(CurrentDate). Use of M02 in Microsoft SQL Server 2000 would result in CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 100)).MonthStartDateReturns the date of the first day of the month in which date or timestamp occurs.Create a metric with M03 = MonthStartDate(CurrentDate). Use of M03 in Microsoft SQL Server 2000 would result in DATEADD(DD, (1 - DAY(GetDate())), GetDate()).AddDaysReturns a date or timestamp plus an offset (+ or -) n days.Create a metric with M04 = AddDays(CurrentDate, 5). Use of M04 in Microsoft SQL Server 2000 would result in DATEADD(DD, 5, GetDate()).AddMonthsReturns a date or timestamp plus an offset (+ or -) n months. If the date does not occur in the new month, the last day of that month is returned.Create a metric with M05 = AddMonths(CurrentDate, -2). Use of M05 in Microsoft SQL Server 2000 would result in DATEADD(MM, -2, GetDate()).MonthsBetweenReturns the difference in months between two dates, as an integer. The difference is number of months elapsed, not number of month boundaries crossed. If the first date argument is later than the second date argument, the result is a negative number.Create a metric with M06 = MonthsBetween('1/3/03',CurrentDate). Use of M06 in Microsoft SQL Server 2000 would result in DATEDIFF(MM, '1/3/03', GetDate()) - CASE WHEN DAY('1/3/03') > DAY(GetDate()) THEN 1 ELSE 0 END.MonthEndDateReturns the date of the last day of the month in which date or timestamp occurs.Create a metric with M07 = MonthEndDate(CurrentDate). Use of M07 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(DATEADD(MM, 1, GetDate()))), DATEADD(MM, 1, GetDate())).YearEndDateReturns the date of the last day of the year in which date or timestamp occurs.Create a metric with M08 = YearEndDate(CurrentDate). Use of M08 in Microsoft SQL Server 2000 would result in DATEADD(DD, -(DAY(GetDate())), DATEADD(MM, (13 - MONTH(GetDate())), GetDate())).YearStartDateReturns the date of the first day of the year in which date or timestamp occurs.Create a metric with M09 = YearStartDate(CurrentDate). Use of M09 in Microsoft SQL Server 2000 would result in DATEADD(MM, (1 - MONTH(GetDate())), DATEADD(DD, (1 - DAY(GetDate())), GetDate())).