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!!! :)
Jump to Post
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 …
All 3 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.