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

[µo°Ý] °²´Á¨É¦³¸ê®æ¨ç¼Æ­pºâ

[µo°Ý] °²´Á¨É¦³¸ê®æ¨ç¼Æ­pºâ

­û¤u¤J¾¤é´Á¬O2015/3/7

¤½¥q°²´Á1¬O2015/4/7 ¤£¨É¦³
¤½¥q°²´Á2¬O2015/5/7 ¤£¨É¦³
¤½¥q°²´Á3¬O2015/6/7 ¨É¦³
¤½¥q°²´Á4¬O2015/6/8 ¨É¦³

­û¤u­n¤u§@º¡3­Ó¤ë¤~¥i¥H¨É¦³°²´Á, ½Ð°Ý¥Î¬Æ»ò¨ç¼Æ¥i¥H­p¥X­û¤u¨É¦³°²´Á3¤Î°²´Á4?

------------------
¦p¦b°²´ÁªíA1 ¤J2015/6/1
¦p¦ó¥i¥H±N°²´Á3¤Î°²´Á4 ¥Î¨ç¼Æ¨ú¥X
B1 2015/6/7
B2 2015/6/8

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-7 08:20 ½s¿è

¦^´_ 1# missbb
¥Ñ1#µLªk¤F¸Ñ¸ê®Æ©Ò¦b°t¸m¬°¦ó¡A¥i¥H´£¨Ñ½d¨ÒÀÉ¡H
«Øij¥Ñ¨ç¼Æ DATEDIF(start_date,end_date,unit) ©Î³w¥Ñ¡u¤J¾¤é´Á+90(¤u§@º¡3­Ó¤ë=90¤Ñ)¡v³B²z®É¶¡°Ï¶¡ªº­pºâ
½Ð°Ñ¦Ò¡I

TOP

[attach]21661[/attach]¦^´_ 2# p212

§ó·s¤Fªí¹F¤èªk, ·Q½Ð±Ð¨ç¼Æ¤è­±ªº¥Îªk?

«ô°U:D

TOP

°²´Á TEST.rar (13.53 KB) ¦^´_ 3# missbb


¤£¦n·N«ä, ¸É¦^ªþ¥ó.
½Ð¨ó§U«ü¾É!

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-8-10 10:07 ½s¿è

¦^´_ 4# missbb
¤½¦¡¤U±o¤£¬O«Ü¦n¡A§Æ±æ¼È¦³À°§U¡A½Ð°Ñ¦Ò¡I

°²´Á TEST_ref.zip (13.62 KB)

TOP

¦^´_ 5# p212


    ¦hÁÂ

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD