Hijiri Date Query

[undee69]

Good day to all..

I am asking again your assistance but for today its about date() functions.

I have an vehicles which its expiration date is set in Hijiri. Now I am trying to get which of the dates has expired or will be expiring let's say in about a month.

Hijiri and Gregorian calendar has a large date gap so i am not sure where to start.



Your assistance is very well appreciated.

[alcapps]

usually you add days to your check date and ask for anything less than that date.
checkdate would be Date + 30
where clause would be
expiringdatefield between Date() and (Date() + 30) and not completed ever how you know that in your table

if you want if for a month only then try
expringdatefield between #1/1/2013# and #1/31/2013#

I hope this helps

[undee69]

our system is in Gregorian calendar. I have tried that already and since Hijri Date is "late" than the Gregorian calendar, it shows all of the Hijri dates as expired..

[alcapps]

sorry.. I don't know that calendar type. Is that a regional setting? I guess your only option is to create a table with those dates and create a gregorian to hijri conversion table and work from there.

[undee69]

Hijri calendar is the one that uses Arabic system.. Im also not sure the formula in coverting Hijri-Gregorian-Hijri calndar; and yeah if there's one way to convert them I would be on my way ^_^