HOW TO FILTER THIS

Discussion in 'Requests' started by sattam, Jan 10, 2022.

    
  1. sattam

    sattam Active Member


    Dear respected Developer,

    I have value In collection

    Compute:Supplier period: $Supplierperiod (Like 042021,052021,062021,.......,032022 etc)

    Now I have to filter this value with period
    Like when period is 1-04-2021 to 31-08-2021 then its return only those which Supplier period is 042021,052021,062021,072021 and 082021

    how can I get this please help me.
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Try to use this method, It probably will work

    1. Create a Date string to make it Simple Example:-
    Compute: Supplier Period: $$Sprintf:"01-%s":$SupplierDate

    It will return a string which you can just convert into date using Date function ($$Date) and Filter it
     
    sattam likes this.


  3. sattam

    sattam Active Member


    Thanks Himansu Ji good idea
    I think it will definitely work
     


Share This Page