|
最佳回答 |
0
|
ID1208Lv6高级互助发布于2023-10-20 16:27(编辑于 2023-10-20 16:34)
|
SQL吗? 20231019是取当前日期的前一日? where 日期字段= IF($参数=FORMAT(TODAY(),"yyyyMM"),DATEDELTA(TODAY(),-1),DATEINMONTH(MONTHDELTA(TODAY(),-1),-1))
|
|
|
|
最佳回答 |
0
|
Z4u3z1Lv6专家互助发布于2023-10-20 16:29
|
if($参数名=FORMAT(today(),"yyyyMM"),FORMAT(DATEDELTA(today(),-1),"yyyyMMdd"),FORMAT(DATEINMONTH(MONTHDELTA(TODAY(),-1),-1),"yyyyMMdd"))
|
|
|
|
最佳回答 |
0
|
CD20160914Lv8专家互助发布于2023-10-20 16:32
|
where 1=1 and 日期字段='${if(right(参数,2)*1=month(today()),format(DATEDELTA(today(),-1),"yyyyMMdd"),FORMAT(DATEINMONTH(MONTHDELTA(TODAY(),-1),-1),"yyyyMMdd"))}' 

|
|
|