1 Topic by prahousefamily (edited by prahousefamily 2014-02-17 11:57:18)

  • Registered: 2014-02-17
  • Posts: 365

Topic: How To Calculate Age From Birthdate

Hoe to calculate Age from birth date

birth date = date
age =number of year

how to use Expression Editor

Post's attachments

Attachment icon รูปภาพ 007.png 11.66 kb, 421 downloads since 2014-02-17 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: How To Calculate Age From Birthdate

prahousefamily wrote:

Hoe to calculate Age from birth date

birth date = date
age =number of year

how to use Expression Editor


Hello,

date('now') - birthdate + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthdate) then -1 else 0 end)

Dmitry.