expr1: Mid$([textdate],2,6)
expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2))
expr3: Format([expr2],"yyyy\.mm\.dd")
Monday, May 11, 2015
Mengira Umur Mengguna No IC menggunakan MS Access
=DateDiff("yyyy", [TarikhLahir], Date())
expr1: Mid$([textdate],2,6)
expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2))
expr3: Format([expr2],"yyyy\.mm\.dd")
expr1: Mid$([textdate],2,6)
expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2))
expr3: Format([expr2],"yyyy\.mm\.dd")
Subscribe to:
Posts (Atom)
