Hallo snorri,
db = "20050102135155"
datum_db = DATESERIAL(LEFT(db,4),MID(db,5,2),MID(db,7,2))
zeit_db = TIMESERIAL(MID(db,9,2),MID(db,11,2),MID(db,13,2))
datum_now = DATE(NOW())
zeit_now = TIME(NOW())
Gruss aus Luzern,
Daniel
Hallo snorri,
db = "20050102135155"
datum_db = DATESERIAL(LEFT(db,4),MID(db,5,2),MID(db,7,2))
zeit_db = TIMESERIAL(MID(db,9,2),MID(db,11,2),MID(db,13,2))
datum_now = DATE(NOW())
zeit_now = TIME(NOW())
Gruss aus Luzern,
Daniel