Category Archive: Mysql

Mar 03

Mysql – check if a date is between two dates

We need to check if an entered discount is valid. Valid condition is performed when the discount is active. Active is when the date the user enter the data is between start date discount and end date. The simple table to save instance discount is “instance” | Code | StartDate | EndDate | code is …

Continue reading »