# Remove JSON array items whose CreatedDate is not within last 5 minutes
**URL:** https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657
**Category:** General
**Created:** [24 July 2020 15:00 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657 "2020-07-24T15:00:53Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Honer08](https://discourse.nodered.org/u/Honer08)
#### Post date: [24 July 2020 15:00 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/1 "2020-07-24T15:00:53Z")
I have a function ("get only the recent") to filter out JSON items from JSON array where CreatedDate was not created within the last 5 minutes.
OR to put it in another perspective.......
keep all JSON array items that have a CreatedDate within the last 5 minutes.
 
I am just missing something and I can't seem to see it.
```auto
var now = new Date()
console.info("Now: " + now);
var fiveMinutesAgo = new Date()
fiveMinutesAgo.setMinutes(-5)
console.info("Filter by Date: " + fiveMinutesAgo);
var permitDateTime = new Date(el => el.DateCreated);
msg.payload = msg.payload.filter(el => el.DateCreated.includes(permitDateTime.getTime() < fiveMinutesAgo.getTime()))
return msg;
```
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [24 July 2020 15:08 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/2 "2020-07-24T15:08:04Z")
Put some debugging in using node.warn(). Like
`node.warn("permitDateTime"+permitDateTime)`
`node.warn(el.DateCreated.includes(permitDateTime.getTime())`
to get an idea of what the data actually is.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [24 July 2020 15:24 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/3 "2020-07-24T15:24:58Z")
hmm, a few issues.
try this...
```auto
var now = new Date()
var fiveMinutesAgo = now.getTime() - (5*60000); //epoch minus 5 mins
msg.origPayload = msg.payload; //keep old one for reference / debugging
msg.fiveMinutesAgo = fiveMinutesAgo; //add ts it to msg so we can inspect it in a debug set to show complete message
msg.payload = msg.payload.filter(el => new Date(el.DateCreated).getTime() >= fiveMinutesAgo )
return msg;
```
EDIT...
let me explain this line `msg.payload = msg.payload.filter(el => new Date(el.DateCreated).getTime() >= fiveMinutesAgo )`
I have no idea what the `type` of `el.DateCreated` is. It could be a string, it could be a date object - BUT - to get you going, I am taking no chances, so, I create a `new Date` from whatever it is, then get its epoch, then compare it as a number to the `fiveMinutesAgo` variable.
note also, I add a few other items to the `msg` object - this is so I can view / debug the whole operation in the debug sidebar (set your debug to show complete message)
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [24 July 2020 15:34 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/4 "2020-07-24T15:34:28Z")
I will say one more thing - where are you getting this data? from a database? If so, you _really_ should be doing this at the database side with a `WHERE` clause.
---
### Author:  [@Honer08](https://discourse.nodered.org/u/Honer08)
#### Post date: [24 July 2020 18:43 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/5 "2020-07-24T18:43:06Z")
Thank you! So very much!
---
### Author:  [@Honer08](https://discourse.nodered.org/u/Honer08)
#### Post date: [24 July 2020 18:45 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/6 "2020-07-24T18:45:26Z")
This data was retrieved from Wufoo, using the Wufoo http get API.
But, I agree. Using a SQL WHERE clause would be much easier.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [7 August 2020 18:45 UTC](https://discourse.nodered.org/t/remove-json-array-items-whose-createddate-is-not-within-last-5-minutes/30657/7 "2020-08-07T18:45:27Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.