Non-gregorian date

[Rattlesnake]

hi,
I'm using Access 2000
I wanted to know as to how can i access a non-gregorian date in Access. I have the Hijri Calender (Arabic) selected on my system. But when i use the DATE or DATE$ functions it returns the gregorian date.
Is there a way to make it return a Hijri (or the the date corresponding to the calender selected on the system)?

Thanks

 

[DJN]

have a look at the Microsoft Knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;en-us;210178

Look under Right-to-left languages.


David

 

[Rattlesnake]

Thanks DJN.
But the solution suggested in the article is to select the "Use Hijri Dates" option in the Tools-->StartUp menu. When i do this my Gregorian dates are messed up. For most parts of my application i require the gregorian date . I require the hijri date for only a few modules and that too all i need is to retrieve the "current" hijri date.
Is there anyway I can get around this?

I know i'm in a "MESS"