Skip to Content
0
Former Member
Jul 27, 2016 at 02:28 PM

daysbetween function for two dates type NVARCHAR

2362 Views

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