Solved Filter Not Working When Use Hijri Calendar is Set to True (1 Viewer)

Pac-Man

Member
Local time
Today, 21:40
Joined
Apr 14, 2020
Messages
353
Hello,

I'm the demo database attached, records are being entered into Hijri dates. Date 1 and date 2 are two unbound textboxes used to filter records.

I'm trying to filter records between certain Hijri dates, for instance between 06/01/1443 and 06/13/1443. If records are entered in Gregorian calendar, filter works fine but is not working for Hijri dates. Can you please see where I'm doing wrong.

Download Database (I have to use dropbox to share the file because chrome on my phone is getting crashed when I click "Attach files" button)

Best Regards,
Abdullah
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:40
Joined
May 7, 2009
Messages
16,419
can you check if it will work for you?
 

Attachments

  • demo.accdb
    864 KB · Views: 143

Pac-Man

Member
Local time
Today, 21:40
Joined
Apr 14, 2020
Messages
353
can you check if it will work for you?
I have checked the file. It is working partially, i.e. for date 1 filter is applied correctly but date 2 filter is not being applied correctly. To check, please set date 1 = 09/01/1443 and Date 2 = 06/12/1443 (to skip record of 06/13/1443 date).

I see immediate window for created filter string, second date is showing year 2583.
 

Pac-Man

Member
Local time
Today, 21:40
Joined
Apr 14, 2020
Messages
353
I changed the function in module so that it save currently selected calendar and restore at the end of conversion. It fixes the issue of second date incorrect conversion. Thanks for help. Issue resolved.
 

Users who are viewing this thread

Top Bottom