Comparison with fields date format

[#1]

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

[hic]

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.

See also http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

HIC