Desktop application

zeshan athar

mange a product expiry or batch number

1st arrive product first sale

using mysql window form

need this form

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Your Logic should Go Like this (consider 2+ week (15 days atleast) as a marker, if DaysRemaining is less than 15 days then its a warning (yellow))

DaysRemaining= CurrentDate-ExpirayDate

If((DaysRemaining-15days)>CurrentDate)
set Color to white

if((DaysRemaining-15days)
Set Color to Red

if(DaysRemaining-15days)==CurrentDate)
set Color To yellow

if(DaysRemaining==CurrentDate)
set Color To green

This is just Logic you have to follow , try to complete it by yourself , If you stuck then share your code and anyone will help you, but at first try by yourself.
Rajanikant Hawaldar5y ago
Order by expirydate desc. So first in tablets will be displayed on top so medicine store keeper can find the particular in store rack.
zeshan athar5y ago
for example, I add 10 tablets on 20.10.2020
next day add more 10 tablets in stock have different expiry date how they will manage dates according stock
zeshan athar5y ago
my final project medicine store all have done I need mange project expiry dates issue. like this pic show expiry product info
Rajanikant Hawaldar5y ago
You want us to develop software for you or your expecting code for this?