...
A negative difference can be returned when the first column is an earlier date than the second column.
If you use PARSE-AS-DATE and one of the dates in the column is null, the resulting column will be null. If any of the columns contains the string now, then the current date-time will be substituted for it. When now is encountered, the directive applies the same value for now across all rows.
...