Skip to Content
0

webi variable help

Apr 06, 2017 at 04:28 PM

56

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Apr 06, 2017 at 05:22 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

Any suggestions?
webi.png (13.7 kB)
0
AMIT KUMAR
Apr 06, 2017 at 09:00 PM
0

try this.

= If ([Modifications]>[Purchased] in ([Order ID])) Then "YES" Else "NO" ]

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0