I am trying to filter based on dates.
I had it working but then it stopped. I am not sure what change I could have introduced to cause this. I have reviewed youtube and this forum. Most suggestions are related to parsing the date. From what I can tell the dates are being recognized properly.
Your expiration date is “10/26/26” but you’re parsing “YY/MM/YYYY”. It’s possible that you’re comparing 26 with 2026. Did you try YY instead?
L
Thanks. I jusy tried YY instead and it still happens exactly the same.
Hmmm…
Can you share the input and output bundles for your modules?
Or, better yet, share your blueprint with a copy of the CSV data that you feed the aggregator and the iterator?
The above will allow us to see exactly what th modules are receiving and then it might be possible to spot the problem.
L
blueprint.json (26.8 KB)
I have attached my blueprint. The csv file is very simple. here is it’s content:
| Name | Cert Type | Expiration Date | |
|---|---|---|---|
| Test 1 | test1@gmail.com | 10/26/26 | |
| Test 2 | test2@gmail.com | 1/2/24 | |
| Test 3 | test3@gmail.com | 1/3/24 | |
| Test 4 | test4@gamil.com | 2/2/23 |
Thanks!
Hi,
I’m attaching the fixed blueprint without the Monday modules because I don’t have an account there.
What I changed (from memory):
By doing those changes, I got it to go through to the end. I didn’t do full testing(edge cases, testing with dates in the future, etc.).
Hoe that helps,
L
blueprint-fix-2024-10-03-2025.json (11.7 KB)
