Thank you for all your Help, I did it like the below:

   set @ChangedDate = (Select DATEADD(month, 1, CONVERT(datetime, @CurrentDate, 103)))
Set @ChangedDate = (SELECT DATEADD(DAY,1,EOMONTH(CONVERT(datetime,...

Declare @CurrentDate Date = '10/12/2020';

Select Top 1 @CurrentDate,*

From (

Select Top 1 w.*, DaysDiff = DATEDIFF(dd,@CurrentDate,w.WeekDate)

From Weeks w

Where w.WeekDate >= @CurrentDate

Union All

Select Top 1 w.*, DaysDiff = DateDiff(dd, w.WeekDate, @CurrentDate)

From Weeks...

This is my query and working fine if today date and table date in same month:

Declare @CurrentDate nvarchar (20);

Set @CurrentDate = '25/11/2020'

SELECT Top(1) ID FROM Weeks

WHERE

WeekName <> 'ALL'

AND

DATEDIFF(day, WeekDate, CONVERT(datetime,...

You are correct date format dd/mm/yyyy

my question is :

When Today date is 25/11/2020

need to get nearest date in the below table which is (01/12/2020) (ID = 5)

if today date is...

Thank yo So Much,  working fine

We are using sql server 2014, how can i do it

Thank you very much ( HappyGeek), (

I need readable date

Really i don't know where to put , i changed like that 
dateadd(ss,1* (Select cast(@jsndate2 as...

Yes i read and i know it is maximum  2,147,483,647  but the dynamic value return more than that, my question how i can solve that?

Yes i am talking about error when value come like that " 4103049600000+0700"
the problem that this value is dynamic

i changed like the below :

declare @jsondate...

Perfect  Jacob

Any Help?

No any order, just i need to avoided consecutive categories

Ok, May be i need to add more details, the below is the code which have the data:

DECLARE @yourtable TABLE (id int, [name] varchar(100), category_sort varchar(100));
INSERT @yourtable...