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

[Pac-Man]

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

 

[arnelgp]

can you check if it will work for you?

 

[Pac-Man]

can you check if it will work for you?

Thanks a lot for reply @arnelgp, I'm away from PC for two days. I'll check and let you know as soon as possible whether it works for me or not.

 

[Pac-Man]

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]

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.