Add days

[#1]

Hi All,

I am currently creating a Pivot table where in we have a the "START Time" in D/M/YYYY h:mm format and we have a field with "Due day" value.

I am trying to create a Measure "DUE DATE", which would be adding the number of days from "Due day" to "START Time".

I am attaching the sample data along with the expected output.

Thanks in Advance

[#2]

When I use

Date(START TIME (DD/MM/YYYY h:mm)+4) it gives me the answer

However when I use

Date(START TIME (DD/MM/YYYY h:mm)+Due (in days)) it throws a '-' in the text box.

[#3]

PFA.

[Anonymous]

In text box it will give error, but will provide correct result when a single date is selected.

You can just sum up in script as well and generate a new field as

Load

*,

Date(START TIME (DD/MM/YYYY h:mm)+Due (in days))  as Due_Date

from table_name;

Now you can use this field easily..

Regards

Nitin

[SergeyMak]

You can use Interval function.

But firstly it's better to round START Time and Due day to date with Floor function in the load script.

I thin than you can also calculate this difference with Floor(Due day)-Floor(START Time).