Make Single Field as Hijri Calendar to Use it for Calculation

[Kha]

Hello
I have a database base on the Gregorian date, but I want to make only one field that I can write in the Hijri date, how can I do it? Not converting
I want to type on fly as hijri for only one field
I make research I got the following result
The query considers it as text knowing that in the code it has been converted to a date, how can I tell the query that it is a date and not a text so that I can use bulit in functions with it
I attached Sample

 

[sonic8]

If you don't want to do any calculations based on that field, the easiest solution would be to create a Text column to store the Hijri date.

 

[Kha]

If you don't want to do any calculations based on that field, the easiest solution would be to create a Text column to store the Hijri date.

Yes I will do calculations by using DateDiff to find the differences between tow dates

 

[Kha]

Samble Attached

 

[arnelgp]

Yes I will do calculations by using DateDiff to find the differences between tow dates

since the Converted date (to Hijri) is text you'll have to convert it first to Gregorian date before doing the calculation.