Hijri Date Problem Again?

vtrm

Registered User.
Local time
Today, 06:29
Joined
Jun 8, 2005
Messages
21
:confused: I had posted this in an earlier Thread, but since the response did not solve my problem, I am posting this as a new thread.
Here is my actual scenario:

I have a DB with some tables. One of them is "Documents" in which I have the following fields: Doccode, Docnum, isdt_g, exdt_g, isdt_h, exdt_h

There are some documents in which entry of Dates is done in Gregorian (eg., Passport (PPT), Insurance Card (ICR)), while there are some in which entry of Dates is done in Hijri (eg., DocCode "NIC" National ID Card). However I have fields to save both Gregorian & Hijri dates.

In the record addition screen, I have given the user 1 field for entering issue date & 1 for the expiry date, (calendar based on the doccode).

So, he may enter 2 records like
PPT - 12345 - 01/jun/2006 - 31/may/2016 and
NIC - B0012 - 5/5/1427 - 24/8/1437

I need the system to :
Convert the PPT dates into Hijri and save all the 4 values to the table, &
Convert the NIC dates into Gregorian and save all the 4 values to the table

Can anyone give me the best solution.

NOTE:
I know the Tools-Options-Use Hijri Calendar checkbox. I tried enabling it in the script. I does, but takes effect only after I shut down the Database and reopen. I cannot do that.
 

Users who are viewing this thread

Back
Top Bottom