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

Question

1.00/5 (2 votes)

See more:

Am creating a software reminder for patients, where i need help is let say a patients came today (21-07-2022) for medical check-up and the interval for medical check-up is 2 weeks, i want it in such a way that the moment today has passed (21-07-2022) it will automatically schedule the patient to (04-08-2022) for another check-up by updating today (21-07-2022 to 04-08-2022). any idea please.

What I have tried:

Haven't tried anything, just looking for an idea or sample

Posted 21-Jul-22 4:57am

Member 13591430

Updated 9-Mar-23 10:36am

PIEBALDconsult

v2

Add a Solution

Comments

Richard MacCutchan 21-Jul-22 11:07am

- Get the check up date and interval
- if check up date is less than today -> nothing to do
- if check up date is greater than today:
--- add interval to check up date
--- save new check up date
--- send reminder to patient

[no name] 21-Jul-22 11:29am

Awesome, you just gave a clue, thank you very much

Richard MacCutchan 21-Jul-22 11:42am

You are welcome.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-07-21T05:46:00

To add to what Richard has said (and remove this from the unanswered list) ...

Working out how to solve a problem is a big part of the task: it's teaching you "how to think" about a problem - any problem, not just software - in a way that gives you a way to get from "Help!" to "Solved" for yourself. And the methods are exactly the same when faced with a software problem as they are in the real world - and teh chances are that you can already use them without thinking about it!

Have a look here: How to Write Code to Solve a Problem, A Beginner's Guide[^].
It should help you with the next problem!