Please , help me

[kamal s.salama]

easily I count age of anyone if I know his birth date , by query I get his
birthday and assume Expr1 = the day today( = date() ) then I extrat the age:
, ite's equal birthdate - Expr1/365 , I have no problem if the date enter in
english , my problem if the date enter in arabic such as 01/01/1402 I can't
deduct from date() the tow dates differents about each other , how I solve
this problem

 

[KARL DEWEY]

Use an IIF statement. I do not know the difference between your arabic date
and Access (english) date but in the formula below it is represented by XX.

Age: IIF(Year([YourBirthDateField]) <1800,
DateDiff("yyyy",([YourBirthDateField] + XX), Date()),
DateDiff("yyyy",[YourBirthDateField], Date()))