Hijri (Arabic) date to Gregorian date converter module .. (1 Viewer)

[tamangspace]

Now when enter the greg date , the hijri says the same as i asked for a translation. for example:
gredate = 01/07/2017 hijridate= 01 rajab 2017

to solve in an awkward way , i have to change the year to 2016 or any number, the hijridate comes out ok. then i have to change back the correct year and the correct arabic hijri appeared

I am also surprised why this kind of result you are getting. Did you edited the function?

Is your computer's date and time and time zone correct?

Check your date format like mm/dd/yyyy or dd/mm/yyyy?

I am not sure it affects or not. But I think It should be in the same format as expected the result!

Which Operating system is in your computer?

Are you using Arabic Version of OS?

Which calendar is active in your ms access? Are you using hijri calendar in default?

Which version of Office Program you using?

if Office 2013 then, Click file>> Options >> Client Settings>> Use Hijri Calendar.

if 'Use Hijri Calendar' is checked, then uncheck it.

See if it worked.

If not then,

Create a new access database and create a form, no tables needed. Try changing the dates in that form. If it works there, then your previous database have some problems.

Good Luck

 

[Akai90]

is there any code to convert the hijri calender format ?

from 1/3/1433
to Rajab 9, 1443h