Using a router then filtering morning or afternoon

Questions
,
1

Hi, I have a question and need some help. I have an array of times in UTC eg 2025-09-19T02:30:00Z I need to format this to NZT and then filter that to morning or afternoon e.g 9-12 and 12-17….for the life of me I cannot work out what the filter format should be - any help greatly appreciated Thank

3

Hi Chris,

You can do this by making smart use of formatting your date and time to a version that says whether it’s AM or PM. You can do so by using the following filters after your router:

image
image441×532 27.7 KB

image
image442×534 28 KB

Hope this helps!

4

Thank you - I knew there had to be an easy solution just couldn’t see the forest for the trees. Thanks again, much appreciated.