Update next check-up date in database using MySql after today

Hello Abdu,

You can call the database store procedure for get date.

Create a store procedure and add logic like below

declare @weekAfter int = 2
declare @dynamicDate date = '2022/07/21'
SELECT DATEADD(week, @weekAfter, @dynamicDate) AS DateAdd;

Here you can pass @weekAfter value suppose you want to get date after 2 week then pass 2 and same for current @dynamicDate if it's always current date then you can use GETDATE() directly.

And if you want to add days then you can also use days like

SELECT DATEADD(day, 15, GETDATE()) AS DateAdd;