如何使用日期过滤器按列检查数据

如何使用日期过滤器按列检查数据

如何在表中找到按日期在列中添加的新值?

我有一张表格,其中有一列是我客户的合同号码,但我想做一个比较,如果我在之前的日期有 X 份合同,而在当前的日期我有一个额外的合同号码,它会将这些新合同描述为“新合同”,如果前一天合同在当天合同栏中消失,那么就会出现“合同结束”的情况。

我怎能这样做?

我的桌子图片:https://i.stack.imgur.com/UQafy.png

OBS:我的表的名称:“ECCR28”,我想要使用的列“CC”是我的合同列,“DATE”是合同日期

TABLE CSV: `"","AGENCIA","REFERENCIA","CD_PRODUTO","CC","NM_CLIENTE","OPERACAO","VL_LIMITE","VL_UTILIZADO","PC_TAXA","DT_CONTRATO","TP_CONTRATACAO","DT_VENCIMENTO","INDICADOR_SEGURO","DT_VENC_SEG","ST_CONTRATO"
"1","0011",2022-12-07,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00","  100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"2","0011",2022-12-07,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00","  100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"3","0011",2022-12-07,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00","  100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV""49","0011",2022-12-08,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00","  100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"50","0011",2022-12-08,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00","  100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"51","0011",2022-12-08,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00","  100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"52","0011",2022-12-08,"0026","011003988-2","RODRIGO MENNA BARRETO","01100398820026001","1.200,00","1629,75","  100,00",2020-12-15,"AA",2021-12-14,"N",NA,"VENC"`

相关内容