Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be using date#(), like:
Today()-date#([skey_date_order],'YYYYMMDD') as [#Days in BO]