自定義數據如下名稱(數據標識)
SZ000967 1130416
SZ002078 1130326
SZ002018 1130525
SH600225 1130321
SZ002466 1130316
SZ000893 1130315
SZ300266 1130508
SZ300032 1130323
SZ000038 1130427
SZ300283 1130528
SZ002309 1130205
SZ300200 1130318
SH600053 1130219
SZ002537 1130518
SZ002219 1130412
SZ300138 1130419
SZ000506 1130507
SZ002383 1130417
SZ002515 1130503
SZ002377 1130504
SZ000710 1130518
SH600759 1130205
SZ000669 1130228
SZ000023 1130125
SH600738 1130330
SZ300339 1130528
SH600687 1130305
SZ300118 1130408
SH601789 1130507
SZ002607 1130523
SZ002512 1130423
SZ002575 1130427
公式目標:
日期:Selfdata('抵押日DZH格式'),linethick0,PRECIS0;
DRAWTEXT(date=日期,high,NUMTOSTRN(YEAR,0)+'-'+NUMTOSTRN(MONTH,0)+'-'+NUMTOSTRN(DAY,0)),colorred;
日期變通1:=if(date=日期 and WEEKDAY=6,(日期+2),(日期));
DRAWTEXT(日期=日期變通1 and WEEKDAY=6,high,NUMTOSTRN(YEAR,0)+'-'+NUMTOSTRN(MONTH,0)+'-'+NUMTOSTRN(DAY,0)),colorred;
我寫的如上自定義數據SZ002018 1130525
日期當日是周六的,就不能在緊隨下周一處輸出數據,不知錯現在哪里,請求指點,謝謝
補充一下,我發帖公式自定義數據引用名處改一下和這組自定義數據名對應,我忘了對應一下,公式就是這樣,但是遇到自定義數據日期為周六的沒法再緊挨著的下個周一顯示,謝謝
日期:Selfdata('wang'),linethick0,PRECIS0;
DRAWTEXT(date=日期,high,NUMTOSTRN(YEAR,0)+'-'+NUMTOSTRN(MONTH,0)+'-'+NUMTOSTRN(DAY,0)),colorred;
DRAWTEXT((日期+2)=date,high,NUMTOSTRN(YEAR,0)+'-'+NUMTOSTRN(MONTH,0)+'-'+NUMTOSTRN(DAY-2,0)),colorred;