PHP SQL to find customers who are on a six month renewal
$10-30 AUD
Status
Publicerad nästan fem år sedan
$10-30 AUD
Betalning vid leverans
Customers buy from us.
purchasedate: YYYY-MM-DD HH:MM:SS
renewaldate: YYYY-MM-DD HH:MM:SS
Ignoring the day and time.
I want to know which customers are renewing at the six month mark; i.e. purchasedate and renewaldate can be divided by six months.
So, this month, I need to know people who purchased in December 2018, June 2018, December 2017, June 2017, December 2016, June 2016, etc.
Next month I'd need to know people who purchased in January 2019, June 2018 January 2018, June 2017, January 2017, June 2016, January 2016, etc.
Thanks!
Hello?
Nice to meet you.
I am excited to work with you on this project. I am ready to start work immediately.
I have good skills in those.
So I think I can help you if you want.
Thank you.
Best Regards.
Hello Sir,
I can write queries to display data in 6 month and 1month slot.
I am willing to start right away.
Please check my profile for work and experience.
Regards
Ashwin
Hi,
We can populate a listing where users can be shown whose renewal are on six month. Lets discuss this in detail so i can start the work today itself.
Thanks
Regards
Hello !
I am a full stack developer for over 5 years on the freelancer.com.
⭐⭐Especially sql query expert⭐⭐
I have read your description in more detail and have much interest in your project.
I have many experiences what I have ever done before similar to your project.
I think that I can finish your work perfectly as you need ASAP.
If you need to discuss with me for any kind of suggestions or information, please knock me anytime.
I am looking forward to hearing from you very soon.
Thank you.
Hi,
I have read your job description carefully and i am very interested in this job.
I am full stack web developer and i am very confident about this job.
I will complete this job within a few hours.
I can start working right now and hope for your positive response.
Regards,
Ionel.
How do you do?
I am a creditist.
I'm very happy to have a chance of bidding your project.
I have read carefully the descriptions and understood clearly what you want.
I have experience in development of the projects like yours
If you hire me, I'll do my best for your project and finish greatly in a short time.
I'm sure I can satisfy for you as you want.
Now I'm waiting your answer with mind that I desire you to select me.
best regards
i can fix it fast please come to the chat...................................................................................................................................
Hi,
I read you job description and I can do this job very professionally without loosing the quality of work.
Please message me so we can discuss more details about the project.
Thanks,
Neil