Write an expression.

[#1]

Hi,

I have a few fields like Order Number, Order Start date and Order End date.

I want to write an expression where I want to find the total number of days for a particular order number.

So that has to be

Order End date (minus -) Order start date for a given order number.

Can someone please help me with this.

Thank you.

[sunny_talwar]

I think what you have seems to be right, are you not getting the desired output?

[#3]

Hi Sunny,

No I am not getting any output. It is blank. I tried to write an expression under create multi box.

[Anonymous · Accepted solution]

If your data is all on the same line then [Order End date]-[Order Start date] should work fine

[#5]

I got it

Thank you.

[#6]

I got it.

Thank you.