Hi All,
I made a calculation view , and I have 2 columns:
1. BUDAT (posting date ) type NVARCHAR8
2. BLDAT(document date) type NVARCHAR 8
I need to create 1 calculated column which calculates the difference between these two dates.
My approach:
New calculated column: ZDAYGAP type NVARCHAR6
Expression :
if("BUDAT" != ' ' and "BLDAT" != ' ',string(daysbetween(date("BUDAT"),date("BLDAT"))), ' ')
But it is not giving any result. Always showing result 0.
What is the correct approach for this
Reagrds
Meenu