Hi,
I'm getting my [PatientDateOfBirth] from a table in MS SQL 2000 db. Its stored as 19600227 (yyyymmdd). i've tried several formats but Im' receiving "error" in my query. Any advice?
here's what i've been trying:
and
neither have worked for me. the second code i was getting an error on the underscore and "Int" part...
thanks!
I'm getting my [PatientDateOfBirth] from a table in MS SQL 2000 db. Its stored as 19600227 (yyyymmdd). i've tried several formats but Im' receiving "error" in my query. Any advice?
here's what i've been trying:
Code:
Int((DateDiff('d',[PatientDateOfBirth],Date())/365.25))
and
Code:
Age=DateDiff("yyyy", [PatientDateOfBirth], Now())+ _
Int( Format(now(), "mmdd") < Format( [PatientDateOfBirth], "mmdd") )
neither have worked for me. the second code i was getting an error on the underscore and "Int" part...
thanks!