Webi Variable Help - Compare Dates/Times

[former_member557046]

Hello,

I have the following in a webi report:

Purchased Time:

06/06/2018 12:44:00 PM

Log Time:

06/05/2018 02:13:49 PM

I need to show in a column YES/NO as to whether the Log time is less than (before) the Purchase time. In the case of my example above it would be "YES".

Can anyone help?

Thanks,

Chuck M

[ayman_salem · Accepted solution]

use this formula:

=if FormatDate([Log Time]; "yyyyMMddHHmmSS") < FormatDate([Purchased Time]; "yyyyMMddHHmmSS") then "Yes" ELSE "No"

[former_member557046 · Accepted solution]

Works good. Thanks