Hi everyone! I have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri dates of a series of Gregorian dates generated in my table? I am using SQL query for this. This triggers when I click my Save button for the computation of the premium terms of the customer having an installment payment plan for an item bought. Is there an SQL query to convert Gregorian dates saved into Hijri dates to an Access table? By the way, I am not using any SQL server or Oracle, I use only plain VB.Net 2008 & MS Access 2003/2007. Hoping for helps and thank you in advance!!! :)
I would think that you would have to get the dates from access, write a function to convert this to gregorian and THEN only show the result. Look at the link below's source code (Right click and select "view source") There is a little function there that you can use for the conversion.
http://www.islamicfinder.org/dateConversion.php?mode=ger-hij&day=22&month=9&year=2010&date_result=1
AndreRet,
As I mentioned I already have the code where it displays the Hijri/Gregorian (vice versa) conversion in my forms. What I need is to convert them and save also the corresponding equivalents in the Hijri date column in my Access table. Thanks for the reply though..! :)
From my knowledge there is no direct support for Hijri dates inside ACCESS. The best way is to save them into text form of CCYY-MM-DD.
You must write yur own functions in ACCESS to manage such dates as all the 12 months are 28 days each.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.