DECLARE @no_modification_years nvarchar(max); DECLARE @f...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

DECLARE @no_modification_years nvarchar(max);

DECLARE @from_date date = '2020-01-01';
DECLARE @to_date date = '2020-12-31';

DECLARE @days int = 26;
DECLARE @days_from_date date;
DECLARE @days_to_date date;

DECLARE @weeks int = 280;
DECLARE @weeks_from_date date;
DECLARE @weeks_to_date date;

DECLARE @months int = 60;
DECLARE @months_from_date date;
DECLARE @months_to_date date;

SET @days_from_date = DATEADD(dd, 0, @from_date)
SET @days_to_date = DATEADD(dd, @days - 1, @from_date)

SET @weeks_from_date = DATEADD(dd, 1, @days_to_date)
SET @weeks_to_date = DATEADD(dd, @weeks, @days_to_date)

SET @months_from_date = DATEADD(dd, 1, @weeks_to_date)
SET @months_to_date = DATEADD(dd, @months, @weeks_to_date)

SELECT @days_from_date;
SELECT @days_to_date;
SELECT @weeks_from_date;
SELECT @weeks_to_date;
SELECT @months_from_date;
SELECT @months_to_date;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results