Summation of two fields

[#1]

Hello Experts,

I want to add two fields,

First one is coming from script, I written some logic for it and output of that field is in this format 'HH:MM'.

Second field is subtraction of two different date fields, interval(date1-date2,'hh:mm').

Here, I want sum of 'HH:MM' and 'hh:mm'.

Thanks In advance!!

[swuehl · Accepted solution]

If you are using QV date and time functions to format your value in your first script expression, 'MM' will not return minutes, but month. Please check the Help file for the format codes.

Why are you using different format codes?

In general, if your values still have a numeric representation, just add the values and format using interval.

[#3]

Thanks!!