Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Select data according to certain date

Hi everyone,  I would ask for your support and knowledge to help me to solve this topic. I have a set of prices, for few contracts, launched in some dates. I need to filter all the items which its ...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous ,

 

você pode colocar uma massa de dados aqui como exemplo ?

Anonymous's avatar
Anonymous
Not applicable
5 years ago
DATA_COTACAOAno_ContratoVALORCONTRATO_TIPOMês Contrato
22-08-20122012943Ago3
22-08-20122012938Set3
22-08-20122012949Q43
22-08-20122013972Q13
22-08-20122013988Q23
22-08-2012201310135Q33
22-08-20122013104Q43
22-08-2012201410855Cal3
22-08-2012201511345Cal3
22-08-20122012894Ago4
22-08-201220128895Set4
03-11-20202021646Q44
03-11-202020216427Q34
03-11-202020216408Q24
03-11-202020216343Q14
03-11-202020216275Jan4
03-11-202020206215Dez4
03-11-202020206125Nov4
03-11-202020326572Cal3
03-11-202020316572Cal3
03-11-202020306572Cal3
03-11-202020296572Cal3
03-11-202020286572Cal3
03-11-202020276572Cal3
03-11-202020266572Cal3
03-11-202020256346Cal3
03-11-20202024619Cal3
03-11-202020236015Cal3
03-11-202020225685Cal3
03-11-202020215451Cal3
03-11-202020215635Q43
03-11-202020215515Q33
03-11-202020215362Q23
03-11-202020215292Q13
03-11-202020215245Jan3
03-11-20202020518Dez3

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    camargos88 Na realidade só deverão aparecer os items que Mês_Contrato > mês da data de cotação, e ano_contrato => que ano da data cotação.