Number of days between 2 days

[#1]

Hello everyone,

I have a table with entries that have 2 datefields columns : Receipt Date and IssueDate (Issue is always after Receipt)

I have been using the following expression :

DayNumberOfYear(IssueDate) - DayNumberOfYear([Rct-Date))

and I get some negative values..

Is there a function that would return a positive value for (5-JAN-15) - (31-DEC-14) ?

For this instance Id like a function that would return =5

Is it possible ?

cheers,

alex

[Gysbert_Wassenaar]

Simply subtract the dates: interval(Date1 - Date2,'d')

[ChiragPradhan]

Use Floor function to convert the date to a number. Floor(Date(IssueDate) - Floor(Date(Rct-Date))

Regards

chirag