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
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: