http://saysunny.tistory.com/entry/주민등록번호로-한국나이-만나이-계산ㅁ 한국나이
- Year(Date())-IIf(Mid([Field],7,1)>=3,2000,1900)-Left([Field],2)+1
ㅁ 만나이
- IIf(DateSerial(0,Mid([Field],3,2),Mid([Field],5,2))>=DateSerial(0,Month(Date()),Day(Date())),Year(Date())-(IIf(Mid([Field],7,1)>2,2000,1900)+Left([Field],2))-1,Year(Date())-(IIf(Mid([Field],7,1)>2,2000,1900)+Left([Field],2)))
- Year(Date())-IIf(Mid([Field],7,1)>=3,2000,1900)-Left([Field],2)+1
ㅁ 만나이
- IIf(DateSerial(0,Mid([Field],3,2),Mid([Field],5,2))>=DateSerial(0,Month(Date()),Day(Date())),Year(Date())-(IIf(Mid([Field],7,1)>2,2000,1900)+Left([Field],2))-1,Year(Date())-(IIf(Mid([Field],7,1)>2,2000,1900)+Left([Field],2)))
댓글 0
- 전체
- Android+iPhone+etc.
- Apache+Tomcat
- ASP
- ASP.NET
- DataBase
- HTML / CSS
- JavaScript
- JSP
- Linux Server
- PHP
- Raspberry pi
- Windows Server
- WIPI
- Etc.