[請益] 請教高手要加3個月的程式寫法
如有一個起的變數是2013/04/01
則迄的值就為2013/07/01
但如遇到2013/03/31
則迄的值就要為2013/06/30
目前遇到困擾是31日及2月底日期的判斷
造成程式寫法要寫很多if寫法
不知各位高手有沒有比較簡單的寫法 就可寫出
謝謝
IF MONTH(s_date) >= 10 THEN
LET e_date=MDY(MONTH(s_date)-9,DAY(s_date),YEAR(s_date)+1)
ELSE
LET e_date=MDY(MONTH(s_date)+3,DAY(s_date),YEAR(s_date))
END IF
IF e_date IS NULL THEN
IF MONTH(s_date) >= 9 THEN
LET e_date=MDY(MONTH(s_date)-8,DAY(s_date),YEAR(s_date)+1)
ELSE
LET e_date=MDY(MONTH(s_date)+4,DAY(s_date),YEAR(s_date))
END IF
LET e_date = MDY(MONTH(e_date),1,YEAR(e_date)) - 1
END IF
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 211.22.197.149
→
04/01 15:32, , 1F
04/01 15:32, 1F
→
04/01 15:34, , 2F
04/01 15:34, 2F
推
04/01 15:46, , 3F
04/01 15:46, 3F
→
04/01 15:46, , 4F
04/01 15:46, 4F
→
04/01 15:46, , 5F
04/01 15:46, 5F
→
04/01 15:54, , 6F
04/01 15:54, 6F
→
04/01 16:02, , 7F
04/01 16:02, 7F
→
04/01 16:19, , 8F
04/01 16:19, 8F
→
04/01 16:19, , 9F
04/01 16:19, 9F
→
04/01 16:29, , 10F
04/01 16:29, 10F
→
04/01 16:31, , 11F
04/01 16:31, 11F
→
04/01 16:31, , 12F
04/01 16:31, 12F
→
04/01 16:32, , 13F
04/01 16:32, 13F
→
04/01 16:32, , 14F
04/01 16:32, 14F
→
04/01 16:33, , 15F
04/01 16:33, 15F
→
04/01 16:33, , 16F
04/01 16:33, 16F
→
04/01 16:34, , 17F
04/01 16:34, 17F
→
04/01 16:34, , 18F
04/01 16:34, 18F
→
04/01 16:35, , 19F
04/01 16:35, 19F
→
04/01 16:35, , 20F
04/01 16:35, 20F
→
04/01 16:35, , 21F
04/01 16:35, 21F
→
04/01 16:36, , 22F
04/01 16:36, 22F
→
04/01 16:36, , 23F
04/01 16:36, 23F
→
04/01 16:36, , 24F
04/01 16:36, 24F
→
04/01 16:37, , 25F
04/01 16:37, 25F
→
04/01 17:39, , 26F
04/01 17:39, 26F
→
04/01 17:39, , 27F
04/01 17:39, 27F
→
04/01 17:47, , 28F
04/01 17:47, 28F
→
04/01 17:52, , 29F
04/01 17:52, 29F
→
04/01 20:02, , 30F
04/01 20:02, 30F
→
04/01 20:48, , 31F
04/01 20:48, 31F
※ 編輯: ppking 來自: 36.236.34.149 (04/01 20:53)
※ 編輯: ppking 來自: 36.236.34.149 (04/01 20:58)
推
04/01 21:08, , 32F
04/01 21:08, 32F
→
04/01 21:12, , 33F
04/01 21:12, 33F
→
04/01 21:13, , 34F
04/01 21:13, 34F
→
04/01 21:48, , 35F
04/01 21:48, 35F
推
04/01 22:52, , 36F
04/01 22:52, 36F
→
04/02 00:44, , 37F
04/02 00:44, 37F
→
04/02 00:46, , 38F
04/02 00:46, 38F
推
04/02 00:56, , 39F
04/02 00:56, 39F
→
04/02 02:13, , 40F
04/02 02:13, 40F
推
04/02 02:19, , 41F
04/02 02:19, 41F
→
04/02 08:04, , 42F
04/02 08:04, 42F
→
04/02 08:04, , 43F
04/02 08:04, 43F
→
04/02 08:41, , 44F
04/02 08:41, 44F
→
04/02 08:43, , 45F
04/02 08:43, 45F
→
04/02 08:45, , 46F
04/02 08:45, 46F
→
04/02 08:47, , 47F
04/02 08:47, 47F
→
04/02 08:49, , 48F
04/02 08:49, 48F
→
04/02 11:32, , 49F
04/02 11:32, 49F
→
04/02 12:09, , 50F
04/02 12:09, 50F
推
04/02 12:47, , 51F
04/02 12:47, 51F
→
04/02 12:50, , 52F
04/02 12:50, 52F
→
04/02 12:51, , 53F
04/02 12:51, 53F
→
04/02 12:53, , 54F
04/02 12:53, 54F
推
04/06 17:23, , 55F
04/06 17:23, 55F
討論串 (同標題文章)
以下文章回應了本文 (最舊先):
完整討論串 (本文為第 1 之 6 篇):