
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.