Can we calculate difference between two date variables

[Anonymous]

Dear All,

I am having two date variables V_Startdate and V_Enddate need to calculate Difference between the two date in expression, can any one help me.

=V_End_Date - V_Start_Date

[pathiqvd · Accepted solution]

Hi,

   Please find below image, Change date format in variable overview you will get

[#3]

Hi Rafeee,

create variables like

date1               =date#('03_Mar_2015','DD_MMM_YYYY')

date2               =date#('31_Dec_2015','DD_MMM_YYYY')

=date2-date1     returm 303

[surendraj]

Hi Rafeee,

I tried this,its working for me.the difference between the dates are 183 days.

(or)

try with interval function,

=interval(date(date#(vend_date,'DD-MMM-YYYY'),'DD-MM-YYYY')-date(date#(vstart_date,'DD-MMM-YYYY'),'DD-MM-YYYY'),'DD')

--surendra