Hello Experts,
I have 2 date columns both with the following format.
04/04/2017 06:36:56 PM
I want to display only records where the date/time in column 1 is after/greater than column 2
e.g. col1 :04/04/2017 06:36:56 PM col2: 04/04/2017 01:36:56 PM [show this]
e.g. col1 :04/04/2017 06:36:56 PM col2: 04/04/2017 09:36:56 PM [hide this]
Can anyone help?
Thanks
If col1 and col2 objects datatype is date then use this.
Show/Hide=If([Col1]>[Col2]) Then "Show" Else "Hide"
After that filter on Show/Hide variable where equal to Show.
if datatype is string then first convert in the date datatype and use above formula.
Date1=ToDate([Date1];"dd/MM/yyyy hh:mm:ss a")
similar for other.
Hi,
Its a little more complicated than that.
I enclose the screenshot.
There are 3 rows. As row 2 has a modified column time greater than the purchased. The variable I made says YES.
[= If [Modifications]>[Purchased] Then "YES" Else "NO" ]
But I need to hide lines 1 & 2 as the orderID is the same.
Only row 3 should be displayed. (as purchased < modifications)
we want orderIDs where no modifications have been made.
In this case line 3 has no such modifs.
I guess what I am trying to get to is:
If modified = YES, get the orderID and hide all lines with that orderID.
try this.
= If ([Modifications]>[Purchased] in ([Order ID])) Then "YES" Else "NO" ]
Hi amit,
I did that and I got the same result as the modified column as I have now.
I need to somehow filter line 1 out completely.
can we do max (modifications) in order id or something like that?
thanks