ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð±Ð»yªkªº¼Æ¦r·N²[

[µo°Ý] ½Ð±Ð»yªkªº¼Æ¦r·N²[

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-8-29 16:53 ½s¿è

·s¼W¸ê®Æ§¨.rar (36.32 KB)
ª¦¤å°¸±o­ã´£ª©¥Dªº¤@­Óµ{¦¡ÀÉ¡A¨ä¤¤¤@¬qµ{¦¡½Xªº¼Æ¦r·N²[¤£¤ÓÀ´¡A
·Ð½Ð½ç±Ð!ÁÂÁÂ!

T = Left(Right(F, 15), 10)     '¥DÀɪº¦C11
½Ð°Ý : ³o­Ó15©M10¬O«ç»ò±o¨Óªº?

AÄ檺¦~/¤ë/¤é¡A§Ú«ç»òºâ³£¬O9­Ó¦r¤¸¡A¥[¤W(?)¡A¤]¥u¦³12­Ó¦r¤¸¡A
¦ý¦pªG§ï¦¨   T = Left(Right(F, 12), 9)   µª®×«o¤£¹ï
¬O¤£¬O³sªÅ¥Õ¦r¤¸¤]­nºâ¦b¤º?

TOP

¥»©«³Ì«á¥Ñ jcchiang ©ó 2020-8-31 08:11 ½s¿è

¦^´_ 2# ziv976688


    ÁÙ¦³.xls
Right(F, 15)=2020-08-25).xls
Left(Right(F, 15), 10)=2020-08-25

TOP

¦^´_ 3# jcchiang
ÁA¸Ñ¤F~¸U¤À·PÁ±zªº¤£§[«ü¾É

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD