由于公司的原因,从3月1号开始算新的1年,这样的话,345,算是第一个季度,678是第二个,然后按照自然月来算,3月1号至3月3号算是第一周,然后3月4日至10日算是第二周,这样排下去,然后等到6月1号的时候,6月1号至2号算是第二季度的第一周,前面的5月27号~31号算是上个季度的最后一周,我现在按照当前日期判断,需要把这个第几周提交入库,请教大佬怎么计算么,poseidon大佬帮忙写了,公司如下"第" + NUMTO(IF(DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") > 7 || WEEK(today()) <> WEEK(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01")))))), IF(WEEKDAY(today()) = 0, ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7, 0), ROUNDUP((DATEDIF(if(or(month(today()) = "3", month(today()) = "4", month(today()) = "5"), CONCATENATE(YEAR(today()), "-03-01"), if(or(month(today()) = "6", month(today()) = "7", month(today()) = "8"), CONCATENATE(YEAR(today()), "-06-01"), if(or(month(today()) = "9", month(today()) = "10", month(today()) = "11"), CONCATENATE(YEAR(today()), "-09-01"), if(month(today()) = "12", CONCATENATE(YEAR(today()), "-12-01"), CONCATENATE(YEAR(today()) - 1, "-12-01"))))), today(), "D") - WEEKDAY(today())) / 7 + 1, 0)), 1)) + "周"