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
@wklcarolll Maybe we can use a rather complex filter as below
hey @wklcarolll Sorry for the confusion, but can i just check what you mean by ' T+1 AM and T+2 PM'? Cheers,TheOC
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:
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.
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!
Than you so much, it works!
