how to validate 2 dates (cannot be different months)

Question

firstDate	secondDate
2022-12-02	2023-01-02
..	...

the second date of the month follows the first date of the month, so the month of the date is can't be different

result like this : | firstDate | secondDate | | --- | --- | | 2022-12-02 | 2023-12-02 | | | ... |

If any body knows the query please share.

hy, my expected result is @firstDate = '2022-12-02' and 'secondDate = '2023-12-02', if the input month is different then it cannot be entered/insert — Handi Tjioe, Dec 02 '22 at 05:27

score 0 · Answer 1 · answered Dec 02 '22 at 07:12

0

Compare the month and perhaps the day as well (pseudo code):

Month(firstDate) = Month(secondDate) and
Day(firstDate) = Day(secondDate)

answered Dec 02 '22 at 07:12

Gustav

1 Answers1