cancel
Showing results for 
Search instead for 
Did you mean: 

Date difference in Dashboard Designer

Former Member
0 Kudos

Dear Experts,

We need to show date difference in number format for the Aging analysis .We have 2 dates like Current date and receipt date.Please suggest how to get the aging period as difference of the to dates.

I am using "- "operator but the result is getting in Date format only.please suggest how to this difference date to convert to number format.

Thanks & Regards,

Venkat P

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

just make sure that the excel cell format is general or number (not date)

see the example below

Answers (0)