topic Comparison with fields date format in QlikView

Comparison with fields date format

Thu, 16 Jan 2014 11:07:30 GMT

Hi all.

If I have a field1 date in the format "yyyy-mm-dd hh: mm: ss", how can I do to

see if another field2 in the same format, is out of range

in the range of plus or minus 10 minutes compared to the previous field?

How do I add or subtract 10 minutes from field1 and verify

if field2 is out of range?

Can you tell me some examples in this topic?

THANK

Re: Comparison with fields date format

hic — Thu, 16 Jan 2014 16:12:19 GMT

If the field has been correctly interpreted as a date or timestamp, the numeric value is used at all numeric operations. Which means that the formatting isn't interesting.

Examples:

If Field1 is a date '12/31/2012' and Field2 is a date '2012-12-31', then Field1=Field2 will evaluate as TRUE.
Fabs(Field1-Field2) < 10/24/60 will return TRUE if the field values are less than 10 min apart.

HIC