Hello All, i am trying to filter the record which has been created in the 1st half of that particular month. So basically, I have a record with a column "Created on" (Data type).
on this column, i have to apply the filter to get the records which have been created in the 1st half of the month. For eg. if record created on "11/10/2023, it is created in the 1st half (Before 16th October and so on.
Discussion posts and replies are publicly visible
Hi Adarsh, you can filter the record data after querying that.
a!localVariables( local!data: rule!AT_getEmployee(date: null), local!fixData: index( local!data, where( day(local!data['recordType!{da9ea760-c50b-42bd-ac44-1c1a62930161}Employee.fields.{68245e32-2244-4909-9a6c-845d3969cadb}hireDate'])<16 ) ), local!fixData['recordType!{da9ea760-c50b-42bd-ac44-1c1a62930161}Employee.fields.{68245e32-2244-4909-9a6c-845d3969cadb}hireDate'] )
Note: Here I am querying the record data in local!data, then filter the data that have "hireDate" in the first half of the respective month.