How to calculate no. of days

[abc_18]

Hi,

I need to calculate the no of days in BO, and formula which I am using is :-

Today()-date([skey_date_order],'YYYYMMDD') as [#Days in BO]

But the values which I am getting is in negative values like :-

-20136973

-20136972

-20136902

Where I am doing wrong?

[tresesco]

May be using date#(), like:

Today()-date#([skey_date_order],'YYYYMMDD') as [#Days in BO]