Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2010
    Posts
    36

    Unanswered: Shamsi date for ms access

    Does anyone know about Shamsi date in ms access.

    i need to add shamsi date in my access projects that will be used instead of default date of computer.

    anyhelp is appreciated.
    thanks

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    Google is your friend.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    What the format of the date
    Make shour you are storing the dates as date value then you can just go =format(field name,"dd mmm yyyy")

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    AS Allan said, Google is your friend! Here's a free downlaod that purportedly add Shamsi date/calendar capabilities to Microsoft products such as Access 2003 and later:

    hijri shamsi Free Download - windows software

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Mar 2007
    Posts
    277
    Happy New Year Linq!
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Happy New Year to you, as well, Allan!
    BTW, my little bow-legged pit bull has a request! She'd appreciate it if you'd keep all that white stuff up in the Rockies and not send anymore down here to Virginia for a while! Her legs are so short that she was 'plowing furrows' in the snow with her belly this past week, and she is not amused!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Mar 2007
    Posts
    277
    We have a Yorki that has the same issue so I completely understand. I'll do my best.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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