Hi Team,
i have a job that run's everyday, i want to filter the array objects and extract the records that were modified, created in last 24hrs. i want to check all these 4 fields "C_Created_Date", "C_Updated_Date", "A_Created_Date" ,"A_Updated_Date".
If any one of these date fall under last 24hrs, i want to filter those records. Can you please assist.
input:
[
{
"Id": 212449,
"C_Created_Date": "2018-08-08 21:24:53.284",
"C_Updated_Date": "2023-10-31 15:34:38.926",
"A_Created_Date": "2018-08-08 21:13:13.809",
"A_Updated_Date": ""
},
{
"Id": 212439,
"C_Created_Date": "2018-08-08 22:27:47.442",
"C_Updated_Date": "2023-02-07 14:44:04.138",
"A_Created_Date": "2018-08-08 22:27:42.146",
"A_Updated_Date": "2023-10-31 17:34:12.853"
},
{
"Id": 21234449,
"C_Created_Date": "2018-08-08 22:30:21.739",
"C_Updated_Date": "2023-02-07 14:44:04.138",
"A_Created_Date": "2018-08-08 22:30:16.766",
"A_Updated_Date": ""
},
{
"Id": 423233,
"C_Created_Date": "2018-08-10 17:51:11.862",
"C_Updated_Date": "2023-02-07 14:44:04.138",
"A_Created_Date": "2018-08-10 17:51:07.438",
"A_Updated_Date": ""
},
{
"Id": 56462148,
"C_Created_Date": "2018-09-13 20:58:37.459",
"C_Updated_Date": "2023-02-07 14:44:04.138",
"A_Created_Date": "2018-09-13 20:57:09.180",
"A_Updated_Date": ""
},
{
"Id": 112324,
"C_Created_Date": "2018-09-21 20:43:37.095",
"C_Updated_Date": "2023-02-07 14:44:04.138",
"A_Created_Date": "2018-09-21 20:42:20.070",
"A_Updated_Date": ""
}
]
Thanks for the quick response @Shyam Raj Prasad