PDA

View Full Version : How to set hijri & gregorian date on form access 2007


asifg_ok1
Feb 21, 2010, 03:17 AM
Kindly help me in two areas,
1- I have design a database of "Receiving and Sending document" I want to input both date "Hijri & Gregorian" when I set date format from control panel it show only one format I need both, how I set it?
2- I want to show report with date filter that user selects starting and ending date and see the record. How is it possible?
Thanks for your kind reply
Syed Asif

suhari
Feb 21, 2010, 04:43 AM
use xp_umalqura(Beta). It an Extended Stored procedure designed to integrate the UmALQura Hijri Conversion algorithm with Microsoft SQL Server 2000. By calling the xp_umalqura extended stored procedure (ESP) from SQL Server 2000, you can convert any Hijri date to its equivalent Gregorian datetime value and vice versa using the UmAlQura Algorithm.