Check a given Date is within a Varchar Date list or not in SQL Server

G.Madri

There is a list of dates stored in a table like this. In the Dates column, it calculates and stores the dates between FromDate and ToDate.

I have created a function to merge all the dates and it returns the list of dates as a varchar value like this.

I want to check whether a given date is within that date list or not. I tried, but it doesn't give the required result.

G.Madri

0 3

I got a really simple answer.

Try this :- If you want to check a date between FromDate and ToDate you can try this:

WHERE DATE BETWEEN FromDate and ToDate

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html