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
You can simply add a new custom record field with the below expression and then use it to filter the records.
if( day(rv!record['recordType!{51d93a85-f899-40bf-98c3-744d5c51b519}EAMS Employee.fields.{706e9825-5d59-440a-8eb0-94d8ae5f499a}dateOfBirth_dt'])<15, 1, 2 )