Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
See also http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right
HIC