+ Reply to Thread
Results 1 to 2 of 2

converting hijri date to gregorian

  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    7

    MS Access: converting hijri date to gregorian

    Hi,

    I have two fields, Hijri Date and Gregorian Date.

    I get date in Hijri Date, so I have set the default calendar of MS Access as "Use Hijri Calendar".

    Now, I am trying to convert the Hijri Date to Gregorian Date, the moment user enters the data or in the design phase itself.
    And I also look to have the code compatible with 2010 and 2013.

    I tried few things but it did not work out, need help from you guys.

    Attached is the sample database.
    Dbase_Conversion.zip
    Last edited by mihaufo; 09-20-2014 at 08:59 AM. Reason: editing the title

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: converting hijri date to gregorian

    Check this to know how to do it....

    http://www.access-programmers.co.uk/...d.php?t=246559


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-13-2017, 04:29 AM
  2. convert from Hijri Date to Gregorian
    By noexcel=badwork in forum Excel General
    Replies: 7
    Last Post: 11-04-2014, 03:21 AM
  3. Converting Hijri Date to Gregorian Date from another cell
    By brmuse1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2014, 12:46 AM
  4. [SOLVED] Gregorian Date from Hijri
    By Abdul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2006, 12:25 PM
  5. Gregorian to Islamic Hijri date conversion
    By Del Cotter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-15-2005, 01:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1