Calculation for Past Due Days (Balance)

[#1]

Hi every one,

How I can to calculate the Past Due Days for the Salary for example just i have the Past Due Date

Numer Provider    Past Due Date        Past Due Days

   12345678            25/11/2015             = 25/11/2015   -   today()

   34567811            29/12/2015             = 29/12/2015   -  today()

I mean i dont have a calendary to do this can you help

[sunny_talwar]

May be like this:

LOAD [Numer Provider],

           [Past Due Date],

           ([Past Due Date] - Today()) as [Past Due Days]

FROM ....

[Ricardo_Gerhard]

Dear Omar,

   If you want to know how much days left from today, uses the sintax:

   Today()-[Past Due Date] as "DaysFrom"

   Anyway, you can use other functions like null, date format.

   Please, mark the CORRECT/HELPFULL comment to help us.

Regards,