Please , help me

  • Thread starter Thread starter kamal s.salama
  • Start date Start date
K

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
 
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()))
 
Back
Top