Calculate age
- Thread starter Valery
- Start date
Valery
Registered User.
- Local time
- , 18:32
- Joined
- Jun 22, 2013
- Messages
- 363
The other issue, you can create new post.
by the way, how do you want your date to display. french (i see). but how do you format it. is it like yyyy-mm-dd?
__________________
Ok will create a new post. I can't format it as a date. It becomes an expression that is put together... and since it is used only on reports - for printing... it is "ok".
by the way, how do you want your date to display. french (i see). but how do you format it. is it like yyyy-mm-dd?
__________________
Ok will create a new post. I can't format it as a date. It becomes an expression that is put together... and since it is used only on reports - for printing... it is "ok".
Valery
Registered User.
- Local time
- , 18:32
- Joined
- Jun 22, 2013
- Messages
- 363
This worked great - just missing a parenthesis (for the benefit of others):
on sorting, cast the return value from our function into an integer. on your sql:
Age:IIf(IsNull(fnAge([DOB])),Null,CInt(fnAge([DOB])))
Again, THANK YOU
on sorting, cast the return value from our function into an integer. on your sql:
Age:IIf(IsNull(fnAge([DOB])),Null,CInt(fnAge([DOB])))
Again, THANK YOU
Similar threads
Solved
Age Deomgraphics
