How to filter complex structure date

[wklcarolll]

How to filter the date by T+1 AM and T+2 PM given the date format below? Thanks!

Apr 22 2022 02:20 PM HKT

Type: V_String

Size:255

[TheOC]

hey @wklcarolll 

Sorry for the confusion, but can i just check what you mean by ' T+1 AM and T+2 PM'? 

Cheers,
TheOC

[wklcarolll]

Apologies for the confusion.

Let say today is 16 Mar.

If T+1 AM and T+2 PM, means 17 Mar AM & 18 Mar PM. Thanks!

Below is the example of the date format:

Apr 22 2022 02:20 PM HKT

[TheOC]

hey @wklcarolll 

Sorry - still slightly confused on that one.

Please can you provide an example input, and expected output of the workflow you are trying to achieve? Attaching the workflow you have made so far would be useful.

Cheers,
TheOC

[mceleavey]

Hi @wklcarolll ,

I'm also struggling with this.

What do you mean by filter?

Do you mean you simply want to create a field that is that date plus one or two days with AM or PM?

M.

[mceleavey]

Ok, so @wklcarolll I've created the two fields by cutting out the date elements, converting to datetime fields and adding a day to each, incorporating AM and PM. I don't understand what else you want, but this will get you started.

Hope this helps,

M.

[wklcarolll]

Column A is the raw date that I would like to apply the filter.

Let's say today is 22 Feb, I want those with 23 Fab AM and 24 Feb PM (Ticked on the right). Thanks!

[Qiu · Accepted solution]

@wklcarolll 
Maybe we can use a rather complex filter as below

[wklcarolll]

Than you so much, it works!