Filter Data between two Persian date in c#

Question

Hi I want to filter my data which is between two Persian date. Note: Persian date is a string data type like : "1400/02/23" when I want to filter my table in SQL Server I simply write like the code bellow:

 SELECT * FROM Table
 WHERE Date >="1400/01/02" AND Date <="1400/05/10"

but in C# syntax I do not know how to fetch date between two string to use in my filter back-end code. If I simply compare the error raise that string type data can not use comparison operator. I would be glad and grateful if somebody help me

Answer 1

First, convert Persian Date to Gregorian date and then do the comparison.