Date Differences

[vtsit]

Hi to all,

I am trying to calculate the difference in days between two date fields. Is there any way to do this on report level ?

Thanks in advance.

[TejaSurapaneni]

Hi,

Can pls tell me bit more u want no.of days or DOD growth

[vtsit]

No, I just want the difference in days just like in excel.

I could not find an appropriate function to implement this.

Thanks

[TejaSurapaneni]

Just convert the date fields to numeric (using treatas function), after that u can easily get solution.

[PeterWijers]

Teja, vtsit

correct, that works well 

This also covers the year skip, that would not have been solved while using days(Del.Date)-Days(entry.Date)

greeting

[vtsit]

Hi all,

thanks for the replies, I finally managed to solve the problem due to your suggestions.

Thank you so much.

Best regards

Vangelis

[TejaSurapaneni · Accepted solution]

Hi Vangelis,

Happy to hear that, please mark the question as answered.

Thanks,

Teja Surapaneni